B.C.A. (Three Year) DEGREE EXAMINATION, OCTOBER/NOVEMBER 2017.
End Semester Examination
Third Semester
Part II
(Regular/Supplementary)
DATABASE MANAGEMENT SYSTEM
2 C 3502
Time 3 Hours Max. Marks 70
PART — A
Answer any FIVE of the following questions. 4 20 Marks)
1. Explain degree of data abstraction.
2. What is business rule and what is its purpose in data modeling?
3. What is a composite entity and when it is used?
4. What is partial dependency? With what normal form is associated?
5. Define Indexes. Explain with examples.
6. What is denormalization?
7. Write about DDL commands.
8. What is transaction?
PART — B
Answer ALL the following questions. 10 50 Marks)
UNIT I
9. What is the importance of data models?
Or
What are the historical roots of files and file systems?

UNIT II
10. Why are entity integrity and referential integrity important in a database?
Or
How can you develop an ER-diagrams? Explain with examples.
UNIT III
11. What three data anomalies are likely to be the result of data redundancy?
How can such anomalies be eliminated?
Or
What is surrogate key and when should you use one?
UNIT IV
12. List and explain advanced select quaries.
Or
Write an examples for SQL functions.
UNIT V
13. Describe about concurrency control with time stamping method.
Or
What is database recovery management?