Database Management Systems Applications - Jun 2015

Computer Engg (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 R database model with suitable example.(5 marks) 1 (b) Compare SQL and NOSQL databases.(5 marks) 10 (a) Explain Regression analysis in data mining with suitable example.(5 marks) 10 (b) Define data Mining. Explain decision Tree classification algorithm with suitable example.(5 marks) 10 (c) Explain ETL Data Warehouse.(6 marks) 2 (a) Define Transitivity dependency. Explain third normal form with suitable example.(5 marks) 2 (b) Explain view and Index objects in SQL with example.(5 marks)

Answer any one question from Q3 and Q4

3 (a) Explain distinct between the terms serial schedule and serializable schedule with suitable example.(5 marks) 3 (b) Explain MongoDB data modelling with suitable example.(5 marks) 4 (a) Describe crowdsourcing in MongoDB.(5 marks) 4 (b) Explain different concurrency protocols in Database management systems.(5 marks)

Answer any one question from Q5 and Q6

5 (a) Explain 3- tier web architecture with diagram for online shopping database system.(5 marks) 5 (b) Explain database administration in MongoDB.(5 marks) 5 (c) Describe Cassandra database architecture.(7 marks) 6 (a) Describe advantages of Homogeneous and Heterogeneous distributed databases.(5 marks) 6 (b) Explain speedup and scale up in parallel databases in detail.(5 marks) 6 (c) Explain Database Connectivity using MongoDB with suitable Example.(7 marks)

Answer any one question from Q7 and Q8

7 (a) Consider following DTD for bid







Create XML document, XML Schemas and solve the following queries in Xquery.

i) List the item number and description of the item(s) that received the largest number of bids, and the number of bids it (or they) received.
ii) List item numbers and average bids for items that have received
three or more bids, in descending order by average bid(7 marks) 7 (b) Write a short note on
i) JSON ii) Hive(10 marks) 8 (a) Consider following DTD for bibliography











Create XML document, XML Schemas and solve the following queries in XQuery on the bibliography fragment.

i) List books published by Addison-Wesley after 1991, including their year and title.
ii) Find pairs of books that have different titles but the same set of authors (possibly in a different order).(7 marks) 8 (b) Write a short note on
i) Map Reduce in Hadoop
ii) Cloudera(10 marks)

Answer any one question from Q9 and Q10

9 (a) Explain BIS Components in detail.(5 marks) 9 (b) Explain Recommendations algorithm in detail.(5 marks) 9 (c) Define Association Rule Mining. Explain Apriori Algorithm with suitable example.(6 marks)