21P336 (Pages: 2) Name: ...............................
Reg.No: ...............................
THIRD SEMESTER M.Sc. DEGREE EXAMINATION, NOVEMBER 2022
(CBCSS - PG)
(Regular/Supplementary/Improvement)
CC19P CSS3 C11 - ADVANCED DATABASE MANAGEMENT SYSTEM
(Computer Science)
(2019 Admission onwards)
Time : 3 Hours Maximum : 30 Weightage
Part-A
Answer any four questions. Each question carries 2 weightage.
1. Illustrate different concepts in relational datamodel
2. Write a note on selection operation
3. List out and explain the anomalies in relational database design
4. How to add a column to an existing table? Explain with suitable example.
5. Explain foreign key and its importance in table.
6. What is a cursor?
7. Explain the need for concurrency control.
(4 × 2 = 8 Weightage)
Part-B
Answer any four questions. Each question carries 3 weightage.
8. Discuss the main characteristics of the database approach and how it differ from the traditional file
system.
9. Describe the necessity of relation to be normalized.
10. Compare Project Join Normal Form and Domain Key Normal Form.
11. Write queries for the following a) List the students with names starting with A D and K in the student
table b) List the female students with student numbers between 30 and 50
12. Discuss the purpose of creating a view in DBMS.
13. What are the different looping statements used in programming with SQL.
14. Discuss Thomas Write Rule.
(4 × 3 = 12 Weightage)
Part-C
Answer any two questions. Each question carries 5 weightage.
15. Create an ER diagram for Company database.
16. Discuss serializability and its different categories
17. Discuss the features, advantages and disadvantages of OODBMS.
18. Discuss commit protocols for distributed databases.
(2 × 5 = 10 Weightage)
*******
