M.C.A. DEGREE EXAMINATION, MAY 2017
First Year
Data base Management Systems
Time 3 Hours Maximum Marks 70
Section A
Answer any three questions × 15 45]
Q1) Discuss features of database systems and file systems and also describe the advantages of
database systems over file systems.
Q2) Discuss about inter record data structures with suitable example.
Q3) Illustrate guidelines for mapping from conceptual data model to relational and network
data models.
Q4) Explain about IMS database description and IMS data manipulation.
Q5) Discuss about concurrency control and database recovery mechanisms.
Section B
Answer any five questions × 4 20]
Q6) Describe the classifications of information systems.
Q7) Briefly explain about sequential file organization.
Q8) Write about physical address pointer and logical key pointer.
Q9) Briefly explain about hierarchical data model with example.
Q10) Explain about 1st and 2nd normal forms.
Q11) Write about database action diagram.
Q12) Describe the roles of DBA.
Q13) Describe any four relational calculus commands.
Section C
Answer all questions × 1
Q14) What is an expert system?
Q15) What is meant by one to one association?
Q16) Give the DDL commands.
Q17) Define entity and relation.
Q18) Define database recovery.