Acharya Nagarjuna University (ANU) 2006 M.C.A - VI - DATABASE MANAGEMENT SYSTEMS - Question Paper

M.C.A.(Previous) DEGREE EXAMINATION, MAY 2006
PAPER - VI - DATABASE MANAGEMENT SYSTEMS

Time: 3 hours Maximum: 75 marks

part - A - (3 X 15 = 45 marks)
ans any 3 of the subsequent

1. explain the drawbacks of conventional file processing system.
2. describe a data model. discuss their classification.
3. State and discuss the method of designing a relational database.
4. What is hierarchical database? How it is various from relational model?
5. explain the query languages that help to Query Relational Database.

part - B - (5 X five = 25 marks)
ans any 5 of the subsequent

6. describe database and DBMS. provide examples.
7. What is relationship? Why it is to be considered?
8. What is entity, attribute? provide examples. discuss their utility.
9. elaborate update anomalies? discuss.
10. describe and discuss 4th Normal form.
11. elaborate data structure diagrams of network model?
12. What is key constraint?
13. discuss how SQL helps in retrieving data.

part - C - (5 X one = five marks)
ans any ALL of the subsequent

14. describe Relationship.
15. What is BCNF?
16. describe 5th Normal Form.
17. elaborate structure diagrams?
18. Who is DBA?

Earning:   Approval pending.