Acharya Nagarjuna University (ANU) 2006 M.C.A , - exam paper

M.C.A. DEGREE EXAMINATION, DECEMBER 2006
First Year
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 Database concepts.

2. describe a Data model, what is E.R. Model. discuss its utility.

3. What is normalisation. How it helps in designing a database.

4. What is Network model. How it is various from Relational model.

5. elaborate Relational constraints. discuss.

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

6. describe Database and DMBS. discuss the differences.

7. Why relationships are total considered.

8. discuss the classification of Data models.

9. What is data independence. How it is achieved in Relational Model.

10. How do you convert a relational from II NF to III NF.

11. elaborate True-structure diagrams of Hierarchical model.

12. describe Relation and Relationship using sets.

13. What is Relation Algebra. discuss the operations describe in it.

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

14. elaborate the kinds of Relationships.

15. What is the differences ranging from three NF and BCNF.

16. describe four NF (Fourth Normal Form)

17. elaborate Data - structure diagrams.

18. State comparison operations in SQL.

Earning:   Approval pending.