M.Sc. DEGREE EXAMINATION, NOVEMBER/DECEMBER 2017
First Semester
Paper II DATABASE MANAGEMENT SYSTEMS
(Common for M.Sc. (Computer Science and Data Science)
2 20912-A
Time 3 Hours Max. Marks 70
SECTION— A
Answer any FIVE of the following. Each question carries SIX marks.
6 30 Marks)
1. Explain three level architecture of database system
2. What is data model? Describe different data models.
3. Write short notes on nested queries.
4. Differentiate between: update and insert primary and foreign keys.
5. Write about multi value dependency with suitable example.
6. Describe various Symbol used in E-R Diagram.
7. State and explain about ACID properties.
8. Describe principles of database security.
SECTION— B
Answer ALL questions. 10 40 Marks)
9. What are integrity constraints? Explain various types of integrity Constraints with
suitable example.
Or
10. Describe the main characteristics of the database approach in contrast with the file
oriented approach.
11. Write query for the following:
To create a table from a table.
To eliminate duplicate rows.
To add a new column in the table
To sort data in a table
Or

12. What is relational algebra? Explain Fundamental and additional Relational
algebra operators with example.
13. What is normalization? Explain 1NF, 2NF, 3NF and BCNF.
Or
14. Suppose that we decompose the schema,
R into and E). show that this decomposition is
lossless decomposition, If the following set F of FD's holds A
E,B A
15. Explain the various ways in which database backup and recovery can be
implemented.
Or
16. Explain Two Phase Locking protocol. What are its advantages and Disadvantages.
———————