Scribd
Upload
24 views

Css3 c11 - Advanced - Database - Management - System

Uploaded by

Arun Kumar NV
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
24 views

Css3 c11 - Advanced - Database - Management - System

Uploaded by

Arun Kumar NV
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

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)

*******

You might also like