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.
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
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)