M.Sc. DEGREE EXAMINATION, APRIL/MAY 2018.
Second Semester
Computer Science
Paper I DATABASE MANAGEMENT SYSTEMS
2 1720921
Time 3 Hours Max. Marks 70
SECTION — A
Answer any FIVE questions. 6 30 Marks)
1. What are limitations of file systems? How to overcome these limitations by DBMS?
2. Explain the terms Primary key, Candidate key and Super keys with example.
3. Differentiate between natural join and outer join with example.
4. Describe various DDL and DML commands in SQL with syntax.
5. Explain specialization and generalization concepts in ER diagram with suitable
example.
6. Briefly explain about 3rd normal form and BCNF with example.
7. Consider schedule S with transaction T1 and T2. T1 transfer Rs. 150 from account
A to C and T2 adds Rs. 50 into account A. Prepare concurrent schedule with two
phase locking protocol.
8. State and explain various transaction properties.
SECTION — B
Answer ONE question from each unit. 10 40 Marks)
Each question carries 10 marks.
UNIT I
9. Explain three level architecture of database system.
Briefly explain about Views of data.
Or
10. Explain about various data models. And also give the applications of DBMS.

UNIT II
11. Write the SQL Queries for the following
Sailors (Sailor_id, Sailor_name, Rating, Age)
Reserves (Sailor_id, Boat_id, Day)
Boats (Boat_id; Boatname, color)
Find names of sailors who have reserved boat 103.
Find names of sailors who reserved all red boats
Find the colors of boats reserved by the sailor lubber and Gilson
Find names of sailors who reserved red and green boats
Find names of sailors who reserved red boats.
Or
12. Discuss the division and the various types of join operations in the relational
algebra with suitable example.
UNIT III
13. Design an E-R diagram for keeping track of the exploits of your favorite sports
team. You should store the matches played, the scores in each match, the players
in each match and individual player statistics for each match. Summary statistics
should be modeled as derived attributes.
Or
14. What is functional dependency? Explain its usage in database design.
Consider table R with FD's as A BC E and ED A .
The table is in which normal form? Justify your answer.
UNIT IV
15. Explain in detail about Lock based protocols and Timestamp based protocols.
Or
16. How are deadlocks handled in transaction processing?
Write short notes on MAC.