Database Management Systems - Dec 2014

Information Technology Engineering (Semester 5)

TOTAL MARKS: 100
TOTAL TIME: 3 HOURS (1) Question 1 is compulsory.
(2) Attempt any four from the remaining questions.
(3) Assume data wherever required.
(4) Figures to the right indicate full marks.

Answer any one question from Q1 and Q2

1 (a) Explain good database design properties. With suitable example explain the consequences of bad designing.(5 marks) 1 (b) Explain with suitable example SQL aggregate functions.(5 marks) 10 (a) What are the requirements of mobile database? List existing mobile database.(9 marks) 10 (b) What is a decision support system? Explain storage and data retrieval issues related to it.(9 marks) 2 (a) Define serializable schedule. Explain two forms of serializability.(5 marks) 2 (b) What is a relation? What are the properties of relation? Explain with example.(5 marks)

Answer any one question from Q3 and Q4

3 (a) Explain the following extended entity relationship features of E-R model.
i) specialization
ii) generalization
iii) aggregation
iv) attribute inheritance(5 marks) 3 (b) Explain rigorous two phase locking protocol.(5 marks) 4 (a) What is a deadlock? Explain deadlock recovery techniques.(4 marks) 4 (b) Write the syntax for following SQL commands:
i) create table
ii) alter table
iii) drop table
iv) insert
v) delete
vi) update(6 marks)

Answer any one question from Q5 and Q6

5 (a) Explain characteristics and advantages of distribution systems.(8 marks) 5 (b) Detail the procedure for connectivity of MongoDB with java.(8 marks) 6 (a) Explain the need of data fragmentation and types of fragmentation.(8 marks) 6 (b) Explain the speed-up and scale up issues with respect to parallelism.(8 marks)

Answer any one question from Q7 and Q8

7 (a) Draw and explain basic building blocks of Hadoop.(8 marks) 7 (b) Describe XML data model. List the advantages of XML.(8 marks) 8 (a) Explain various components of Hadoop.(8 marks) 8 (b) Write a short note on:
i) Xquery ii) JSON(8 marks)

Answer any one question from Q9 and Q10

9 (a) Draw and explain main components of data warehouse and its characteristics.(9 marks) 9 (b) What are the characteristics of NoSQL cloud database?(9 marks)