Get fully solved assignment. Buy online from website
online store
or
plz drop a mail with your
sub code
we will revert you within 2-3 hour or immediate
Charges rs
125/subject and rs 700/semester only.
if urgent then call us
on 08791490301, 08273413412
DRIVE
WINTER 2014
PROGRAM
MBADS (SEM 3/SEM 5)
- MBAFLEX/ MBA (SEM 3)
PGDISMN (SEM 1)
SUBJECT CODE &
NAME
MI0034 – DATABASE
MANAGEMENT SYSTEM
BK ID - B1966
CREDIT - 4
MARKS – 60
Q1. The data is
stored in the form of tables which can be retrieved efficiently by any program
as per the request. Since the database users are vast in number, the database
provides authentication. Explain the different types of database users.
(Listing at least 4 different database users, Explaining them) 2, 8
Answer:
Types of Database Users:
Database Administrator (DBA)
Database Designers (DBD)
End users
System
analysts and application programmers
Database Administrator (DBA): Database is one of the many
primary resources that is used by many people in an organisation. The
responsibilities of
Q2. Computer storage is divided into primary
memory and secondary memory. Discuss with an example, the different types of
primary memory and secondary memory. (Listing the types of primary memory,
Listing the types of secondary memory, Describing the types of primary memory,
Describing the types of secondary memory) 1, 1, 2, 6
Answer:
The computer
storage is divided into mainly two types:
·
Primary
memory
·
Secondary
memory
Primary storage – It includes storage media that
can be operated directly by the computer central processing unit (CPU), such as
the computer main memory and smaller but faster cache memories.
Secondary storage – It is used with today’s computers
to store all your programs and your personal data even though it is slow
compared to primary memory. The best example is hard disk drive. Although
offline storage is considered to be secondary storage, for your better
understanding, we have classified it separately consid
Q3. Consider any
one example of a relational database and show how the different operations of
relational algebra can be performed on the table showing the output. (Listing
the types and its subtypes, Explaining with an example) 3, 7
Answer: Relational Algebra
The Relational Algebra was introduced by E. F.
Codd in 1972. It consists of a set of operations on relations:
- SELECT (σ):
extracts tuples from a relation that satisfy a given
restriction. Let R be a table that
contains an
Q4.
Describe the different normal forms with one example throughout. (Listing the 5
important normal forms, Definitions for each of them, Explanation for each of
them using one example throughout) 2, 3, 5
Answer:
5 important normal forms: the
following types of Normal Forms.
·
First
Normal Form (1NF)
·
Second
Normal Form (2NF)
·
Third
Q5.
Write Short Notes on: 2, 2, 2, 2, 2
a. Transaction
Commit
b. Atomicity
c. Deferred update
d. Security
e. System log
Answer:
Transaction
commit - Transaction
commit is responsible for making all the data modifications permanent in the
database. When transaction commit occurs, the following are the observations:
·
A
commit record is made to indicate that the modifications are permanent, and
this is written to the log
Q6. With an example
explain the working of ODBMS. (Explaining with an example) 10
Answer:
How do ODBMSs work: Consider an example of Student_Course
relationship. The entity STUDENT has got attributes std_id, std_name
and std_address. The
Get fully solved assignment. Buy online from website
online store
or
plz drop a mail with your
sub code
we will revert you within 2-3 hour or immediate
Charges rs
125/subject and rs 700/semester only.
if urgent then call us
on 08791490301, 08273413412
No comments:
Post a Comment