Advanced Database Management Systems - May 2012

Information Technology (Semester 5)

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.

This Qs paper appeared for ADBMS of Computer Engineering (Semester 5)

1(a) You need to design a database for an art gallery. The database schema must keep information about artist, their names, (which are unique), birth places, age, style of art and photograph. For each piece of artwork, the artist, the year it was made, its unique title, its type of art (e.g. Painting, sculpture, photograph), and its price, along with picture(thumbnail) must be stored. The database also stores information about customers.
For each customer, database stores the persons unique name, address and total amount of money spent in the gallery and the artist and type of art the customer tends to like (can be text).
Draw an EER diagram from the system(6 marks) 1(b) Map the EER to Relations for Q 1(a)(8 marks) 1(c) Take two typical queries and write them in SQL for Q 1(a)(6 marks) 2(a) Explain different architectures of parallel databases(10 marks) 2(b) State comparison of RDBMS, OODBMS, ORDBMS(10 marks) 3(a) Explain data fragmentation, replication and allocation technique for distributed database design.(10 marks) 3(b) Give an overview of 3-Tier client server architecture(10 marks) 4(a) What is SQL-3? Write in detail about features of SQL 3(10 marks) 4(b) What is well formed and valid XML document? With example explain what is XML schema file?(10 marks) 5(a) Explain in detail about heuristic approach to query optimization(10 marks) 5(b) Explain the method for implementing the SELECT operation(10 marks) 6(a) Explain conceptual database design in database design and implementation process.(10 marks) 6(b) Explain concurrency control in distributed database(10 marks)

7. Write short notes on (any two):

7(a) Specialization and Generalization(10 marks) 7(b) Joins in SQL (10 marks) 7(c) Measures of query cost(10 marks)