Ranchi University 2009 M.B.A Data Base Management System IT (3402) - Question Paper

Full marks: 70 Time: three hours

Candidates are needed to provide their answers in their own word as far as practicable

The figures in the margin indicate the full marks.

ans any 5 ques. including Q. No. nine which is compulsory.

1. What is database model? What is relational data model? What is the independence and how
does a DBMS support it? [Marks 14]

2. Identify the main components in a DBMS and briefly discuss. [Marks 14]

3. What is object oriented database model? Compare and contrast the various database
models. [Marks 14]

4. What is the hierarchical database model? Discus the major advantages and disadvantages of
the Hierarchical database model. [Marks 14]

5. What is normalization? discuss the Boyce-codd Normal Form (BCNF). [Marks 14]

6. What is distributed data base? elaborate the components of a distributed database
system? discuss with the help of a diagram. [Marks 14]

7. Write short notes on the subsequent : [Marks 14]
(a) Performance improvement
(b) Recovery problems
(c) Object-Relational model
(d) Structured Query Language(SQL)

8. How does a relational database management system process an SQl statement? [Marks 14]

9. Case-study: [Marks 14]

A company database needs to store info about employee (identified by SSN, with salary and phone as attributes), departments (identified by dno, with dame and budget as attributes), and children of employees (with name and as a attributes) employees work in departments; every department is managed by an employee; a child must be identified uniquely by name, when the parent (who is an employee, presume that only 1 parent works for the company) is known. We are not interested in info about a child once the parent leaves the company.

Draw on ER diagram that captures this info.

Earning:   Approval pending.