Database Management Systems - May 2015

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 ACID properties.(4 marks) 1 (b) Construct an E-R diagram for a car insurance company that has a set of customers each of whom owns one or more cars. Each car has associated with it zero to any number of recorded accidents.(6 marks)

Write a short note on

10 (a) Machine learning for Big data.(4 marks) 10 (b) Mobile database(4 marks) 10 (c) Data Mart(4 marks) 10 (d) KDD(4 marks) 2 (a) Explain different anomalies with example.(6 marks) 2 (b) What is cursor? Explain cursor in PL/SQL with suitable example.(4 marks)

Answer any one question from Q3 and Q4

3 (a) Consider a relational database
Supplier (Sid, Sname, address)
Parts (Pid, Pname, color)
Catalog (Sid, Pid, cost)
Write SQL queries for the following:
i) Find the names of suppliers who supply some red parts.
ii) Find the names of all parts whose is more than Rs. 250.
iii) Find name of all parts whose color is green.
iv) Find number of parts supplied by each supplier.(8 marks) 3 (b) Write short note on Embedded SQL.(2 marks) 4 When do dead lock happen? How to prevent them, how to recover if dead lock takes place.(10 marks)

Answer any one question from Q5 and Q6

5 (a) Why it is necessary to have client-server architecture for database management system.(6 marks) 5 (b) Explain and state difference between centralized and client-server architecture.(8 marks) 5 (c) Explain different issues in design of parallel system.(4 marks) 6 (a) Explain need of partitioning techniques used in I/O parallelism. Explain in techniques in detail.(8 marks) 6 (b) What is distributed database. Discuss different approaches used for data storage in distributed database.(8 marks) 6 (c) What are internet database.(2 marks)

Answer any one question from Q7 and Q8

7 (a) Explain with example DTD.(6 marks) 7 (b) Discuss Hbase data Model.(5 marks) 7 (c) Explain with syntax JSON data type and object.(5 marks) 8 (a) Write a short note on.
i) X path
ii) X Query(6 marks) 8 (b) What is Hadoop Framework and on what concept the Hadoop Framework works.(8 marks) 8 (c) Explain NOSQL database.(2 marks)

Answer any one question from Q9 and Q10

9 (a) What is data preprocessing? Explain data preprocessing techniques.(8 marks) 9 (b) Explain architecture of data mining system.(8 marks)