Osmania University (OU) 2007 B.Com Computer Science Database Management Systems - - exam paper

I. Answer all the subsequent ques. in not exceeding 20 lines every. five X 4=20 Marks

1. Explain the advantages of Database System.
2. What is an E-R diagram? discuss with example.
3. Define a Schema with example.
4. Explain Indexed sequential file organization.
5. Explain the advantages of distributed query processing.


II. ans all ques. in not exceeding four pages every. five x 10 =50 Marks

6. (a). elaborate Risks and Costs associated with database.
Or
(b). describe DBMS. discuss the advantages of DBMS over File Oriented System.

7. (a). (i). discuss the various Integrity Constraints.
(ii). Write a note on Functional Dependency.
Or
(b). discuss how to transform a Conceptual model into Relational model.

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

9. (a). discuss the role of DBA in implementing Standards and Procedures.
Or
(b). discuss various methods of Database Systems.

10. (a) List and discuss the Strategies and Objectives of implementing Distributed Database Systems.
Or
(b) discuss any 2 methods of maintaining Data integrity in Distributed Database System.

Earning:   Approval pending.