Osmania University (OU) 2009 B.Com Computer Science Database Management Systems - Question Paper

I. Answer any 5 ques. in not exceeding 20 lines every. five X 4=20 Marks

1. Database System Components.
2. Define object, relation with example.
3. What are DDL statements?
4. Indexed sequential file organization.
5. Advantages of distributed query processing.
6. Query processing.
7. Database recovery.
8. Strategic database planning.


II. ans all ques. in not exceeding four pages every.

9. (a). describe DBMS. discuss the advantages of DBMS over file oriented system.
Or
(b). List and define every of the 6 steps in the database development life cycle.

10.(a). discuss how to transform a conceptual model into relational model.
Or
(b). describe normal forms and discuss with example.

11.(a). discuss different database change operations with suitable examples.
Or
(b). describe a view with example. discuss various operations on a view.

12.(a). discuss the mapping logical data structures to physical data structures.
Or
(b). discuss the functions of database administrator.

13. (a) What do you know about valuation models?
Or
(b) discuss any 2 methods of maintaining Data integrity in Distributed Database System.

Earning:   Approval pending.