Download JNTUA MCA 2016 Nov 3rd Sem 9F00301 Database Management Systems Question Paper

Download JNTU Anantapur (JNTU Anantapur) Master of Computer Applications (MCA) 2016 Oct-Nov Regular Supply 3rd Sem 9F00301 Database Management Systems Previous Question Paper

Code: 9F00301
MCA III Semester Supplementary Examinations July 2015
DATABASE MANAGEMENT SYSTEMS
(For students admitted in 2009, 2010, 2011, 2012 and 2013 only)

Time: 3 hours Max Marks: 60
Answer any FIVE questions
All questions carry equal marks
*****

*****
1 (a) Explain the importance of database design.
(b) Write the differences between file system and database management system.

2 (a) Draw and explain E-R diagram of an airline reservation system.
(b) What is E-R model? Explain in detail.

3 (a) What is a relationship? Explain different types of relationship in detail.
(b) What is a key? Describe different types of keys used in database.

4 (a) Explain different types of joins with suitable examples.
(b) What are relational set operators? Explain with examples.

5 (a) What are the advantages of normalization?
(b) Explain denormalization with example.

6 (a) Explain the concept of transaction atomicity.
(b) Explain concurrency control with locking methods.

7 (a) What is recovery? Also explain log based recovery.
(b) Explain remote backup system in DBMS.

8 (a) Briefly describe ISAM.
(b) Compare the ordered indexing with hashing.
FirstRanker.com - FirstRanker's Choice