Andhra University 2005 B.Sc Computer Science Database management systems - Question Paper

PAPER -IIII
DATA BASE MANAGEMENT SYSTEMS

ans any 5 ques. (5x20=100)

1.

a. What is an info System? discuss.
b. discuss the main components of a Database Management System

2. discuss with the help of a diagram about different data structures supported by databases

3.

a. Write a note on Entities, Attributes and Associations
b. discuss about Hierarchical Data model with the help of a diagram

4. What is Normalization? elaborate the advantages of having a database normalized? Write a note on 3NF, BCNF, four NF and 5NF

5. What a note Network Databases

6. What is SQL? Write about DML and DDL commands supported in Oracle.

7. What is a Database Deadlock? How can it be recovered? How can database deadlocks be avoided?

8. Write a note on the subsequent

a. Convention File System

b. Entity-Relationship Model

c. Insertion and Deletion Anomalies

d. Checkpoints

Earning:   Approval pending.