Database Management Systems - May 2012

Information Technology (Semester 3)

TOTAL MARKS: 80
TOTAL TIME: 3 HOURS (1) Question 1 is compulsory.
(2) Attempt any three from the remaining questions.
(3) Assume data if required.
(4) Figures to the right indicate full marks. 1(a) Discuss the advantages of Database system over File system.(5 marks) 1(b) What is strong entity and weak entity? Explain with examples.(5 marks) 1(c) Explain different features of GUI.(5 marks) 1(d) What is a view? Write syntax to create view using SQL.(5 marks) 2(a) Consider a car-insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents. (i) Design an EER schema, stating any assumptions you make.(5 marks) 2(a) (ii) Show mapping of EER schema to relational schema.(5 marks) 2(b) Explain following relational algebra operators with example:
(i) Project
(ii) Rename
(iii) Division
(iv) Natural Join
(v) Set Difference(10 marks) 3(a) Explain different states and properties of transaction?(10 marks) 3(b) What is deadlock? Explain different techniques to prevent and recover from deadlock. (10 marks) 4(a) Consider the following global schema which keep track of airline flight information. Answer the following queries in SQL:
Flights (flno, from, to, distance, departs, arrives, price)
Aircraft (aid, aname, cruisingrange)
Certified (eid, aid)
Employees (eid, enarne, salary)
i) Find the names of pilots certified for some Boeing aircraft.
ii) Find the aids of all aircraft that can be used on routes from Mumbai to Delhi.
iii) Find the names of pilots whose salary is less than the price of the cheapest route from Mumbai to Chennai.
iv) For each pilot who is certified for more than three aircraft, find the eid and the maximum cruising range of the aircraft for which she or he is certified. (10 marks) 4(b) Explain the use of logs and check points for recovery in a database. (10 marks) 5(a) Explain Murphy's Law of GUI design.(5 marks) 5(b) Write a note on ActiveX Data-Object (ADO).(5 marks) 5(c) What is serializable schedule? Describe with suitable example differenttypes of serializable schedule.(10 marks) 6(a) What is concurrency control? Explain the two phase locking protocol andgraph based protocols.(10 marks) 6(b) Explain the shadow page recovery technique.(5 marks) 6(c) Write a note on icons and graphics.(5 marks)

Write short notes on :-

7(a) Responsibilities of Database Administrator(5 marks) 7(b) Generalization and Aggregation(5 marks) 7(c) List box, Combo box, Check box controls of VB.(5 marks) 7(d) Referential integrity in SQL(5 marks)