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

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

1. Mention the Data Models in Database Systems. discuss Relational Model.
2. Explain 2nd Normal Form with 1 example.
3. What are the operators available in Relational Algebra?
4. Explain checkpointing in database.
5. Mention the strategies and objectives of Distributed Database System.


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

6. (a). discuss the functions of Database Administrator.
Or
(b). discuss the several services given by DBMS.

7. (a). State all Normal Forms. discuss Boyce-Codd Normal Form with an example.
Or
(b). discuss the terms.
(i) Functional Dependency
(ii). 3rd Normal Form

8. (a). discuss Stored Procedures in detail.
Or
(b). discuss schema, table, view. How do you create schema, table and view in SQL.

9. (a). discuss the disk performance factors in detail.
Or
(b). discuss the method of preventing the concurrency issue.

10. (a) Briefly discuss important considerations associated with DBMS implementation.
Or
(b) discuss the general model of Distributed Database System.

Earning:   Approval pending.