Database Management Systems Applications - Dec 2014

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) Design E-R model for Online Book Shop Database System
i) List the entity sets and their primary keys
ii) Extend the E-R diagram, using Specialization(5 marks) 1 (b) Define normalization. Explain three normal forms with suitable example.(5 marks) 10 (a) Explain Data Mining classification task with suitable example.(5 marks) 10 (b) Define Machine Learning. Explain supervised and unsupervised learning with suitable example.(5 marks) 10 (c) Explain Data Warehouse Architecture in detail.(6 marks) 2 (a) Explain MongoDB CRUD operations with suitable example.(5 marks) 2 (b) Consider following relational tables
instructor (ID, name, dept_name)
student (ID, dept_name, tot_cred)
takes (ID, course_id, sec_id, semester, year)
course (course_id, title, dept_name, credits)
Dept (Dept_id, dept_name)

Solve following quries using SQL
i) Design above relation tables using SQL DDL statements, primary key and foreign key
ii) Find the names and average salaries of all departments whose average salary is greater Than 42000.(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 aggregation using MongoDB with suitable example.(5 marks)

Write a short note on (any two):

4 (a) Crowd sourcing(5 marks) 4 (b) Two phase locking protocol(5 marks) 4 (c) Query optimization in NoSQL.(5 marks)

Answer any one question from Q5 and Q6

5 (a) Explain 2-tier and 3-tier architecture with diagram for online Banking Database system.(5 marks) 5 (b) Explain any two parallel Database System Architecture in detail.(5 marks) 5 (c) If we are to ensure atomicity, all the sites in which a transaction T executed must agree on the final outcome of the execution T must either commit at all sites, or it must abort at all sites. Describe the Two Phase Commit Protocol used to ensure this property in detail.(7 marks) 6 (a) Compare homogeneous and heterogeneous distributed databases.(5 marks) 6 (b) Explain Cassandra database 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) What is JSON ? Explain JSON schema with example.(5 marks) 7 (b) What is HBase? Explain data models in detail.(5 marks) 7 (c) Consider bibliography database system for different database entities such as book, book year, author, editor, title, publisher, price etc. Design XML DTD with Constraints for Bibliography Database System.(7 marks) 8 (a) Explain XPath and Xquery with suitable example.(5 marks) 8 (b) Explain HIVE database in detail.(5 marks) 8 (c) Explain different components of Hadoop in details.(7 marks)

Answer any one question from Q9 and Q10

9 (a) Explain BIS components in detail.(5 marks) 9 (b) Compare operational system and data warehouse.(5 marks) 9 (c) Define clustering. Explain any clustering algorithm with suitable example.(6 marks)