Database Management Systems - Dec 2011

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 main categories of data models.(5 marks) 1(b) State five main advantages of using a DBMS. (5 marks) 1(c) Explain ACID properties of transactions.(5 marks) 1(d) Explain with examples the decision making statements and loop structures statements in VB.(5 marks) 2(a) What are the different types of database system users?(5 marks) 2(b) List the functions of a database administrator (DBA).(5 marks) 2(c) Draw an E-R diagram which models an online bookstore. List entity sets and the primary keys.(10 marks) 3(a) What are the conditions for the schedules S & S' to be view equivalent? When do we say a schedule S is view serializable? (10 marks) 3(b) Why transaction processing systems usually allow concurrent executions? Give Reasons(10 marks) 4(a) Brief about validation based concurrency control scheme.(10 marks) 4(b) Explain deadlock prevention in detail. (10 marks) 5(a) For the following relations for a book club:-
(i) Members (Member-id, Name, Designation, Age).
(ii) Books (Bid, Btitle, BAuthor, Bpublisher, Bprice).
(iii) Reserves (Member-id, Bid, Date)
where Bid, Btitle, BAuthor, Bpublisher and Bprice are book identification, book title, book author, book publisher and book price respectively.

Write the following queries in SQL.339
(1) Find the names of members who are professors older than 45 years.
(2) List the titles of books reserved by professors.
(3) Find IDs of members who have reserved books that cost more than Rs. 500.
(4) Find the authors and titles of books reserved on 11-11-2011.
(5) Find the names of members who have reserved all books.(10 marks) 5(b) Describe two-phase locking protocols and graph based protocols. (10 marks) 6(a) Write a note on relational algebra.(10 marks) 6(b) Describe the use of logs and check points in a database.(10 marks)

Write short notes on (any four):-

7(a) DDL and DML(5 marks) 7(b) Transaction support in SQL(5 marks) 7(c) Features of GUI(5 marks) 7(d) ActiveX data objects (ADO)(5 marks) 7(e) Extended E-R features(5 marks) 7(f) Shadow paging recovery technique(5 marks)