B.C.A. (Three Year) DEGREE EXAMINATION, OCTOBER 2018.
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. What are the problems with file system?
2. Give an examples for keys.
3. What are Data definition commands?
4. How can you add primary and foreign keys?
5. What is transaction?
6. What is derived attribute? Give an example.
7. What is Joining? Explain different types of joints.
8. Write about the importance of Data modeling.
PART — B
Answer ALL the following questions. 10 50 Marks)
UNIT I
9. Give an examples of each of the three types of relationships.
Or
List and describe the different types of databases.

UNIT II
10. Why are entity integrity and referential integrity important in a database.
Or
What are conflicting Goals? Explain each one.
UNIT III
11. Explain 2nd and 3rd normal forms with example.
Or
What is the need for normalization?
UNIT IV
12. Give an examples for Advanced select queries.
Or
What is stored procedure, and why is it particularly useful?
UNIT V
13. List and discuss the four transaction properties.
Or
What is database recovery management?
———————