MU Computer Engineering (Semester 4)
Database Management Systems
May 2014
Total marks: --
Total time: --
INSTRUCTIONS
(1) Assume appropriate data and state your reasons
(2) Marks are given to the right of every question
(3) Draw neat diagrams wherever necessary


1(a) List four significant difference between file processing system and database management system.
5 M
1(b) Explain shadow page recovery.
5 M
1(c)

Explain the terms. Total participation and partial participation' with example.

5 M
1(d) Explain lossless join decomposition and dependency preserving decomposition.
5 M

2(a) Explain conflict serializability and view serializability with examples.
10 M
2(b) Construct an ER diagram and relational model for hospital with a set of patients and a set of medical doctors. Patients are treated in a single ward by the doctors assigned to them.Each patient will be treated by a single doctor.Healthcare assistants also attend to the patients, a number of these are associated with each ward. Patient undergoes various tests. Account department managers patient treatment bill and staff payment.Some staff are paid part time and doctor and care assistance work varying amounts of overtime at varying rates(subject to grade).
10 M

3(a)

What is an attributes? Explain different types of attributes with examples.

10 M
3(b)

Write SQL queries for the given database.
Sailor(sid,sname,rating,age)
Boat(bid,bname,color)
Reserves(sid,bid,date)
i) Find the names of sailors who have reserved 'red' boat.
ii) Find the sailor name with highest rank
ii)i Find the average age of sailor.
iv) Find the age of youngest sailor for each rating level.
v) Add the new boat to the database. Assume any values for required attributes.

10 M

4(a) Explain the term super key,primary key,candidate key and foreign key giving suitable examples.
10 M
4(b) What is normalization ?Explain 1NF,2NF,3NF,BCNF with suitable examples.
10 M

5(a) Explain domain constraints and referential integrity constraints.
10 M
5(b) Explain sort-merge join algorithm in query processing.
10 M

6(a)

Explain following relational algebra operational with examples:
i) set intersection
ii) generalized projection
iii) natural join
iv) Division operator

10 M
6(b) Describe the overall architecture of DBMS with suitable diagram
10 M



More question papers from Database Management Systems
SPONSORED ADVERTISEMENTS