Database Management Systems - Dec 2014

Computer Engineering (Semester 4)

TOTAL MARKS: 80
TOTAL TIME: 3 HOURS (1) Question 1 is compulsory.
(2) Attempt any three from the remaining questions.
(3) Assume data if required.
(4) Figures to the right indicate full marks. 1 (a) Define specialization and Generalization with an example.(5 marks) 1 (b) Write about Aggregate Function in SQL.(5 marks) 1 (c) Discuss Referential Integrity Constraints.(5 marks) 1 (d) Explain Total Participation and Partial Participation with example.(5 marks) 2 (a) Explain the following Relational Algebra Operations with example:-
i) Set Intersection
ii) Division Operator
iii) Generalized Projection
iv) Natural join(10 marks) 2 (b) Draw an ER Diagram for a banking enterprise. Convert it into relational model.(10 marks) 3 (a) What is Normalization? Explain INF, 2NF, 3NF and BCNF giving examples.(10 marks) 3 (b) What is an attributes? Discuss various types of attributes with examples.(10 marks) 4 (a) Explain sort-merge join algorithm in query processing.(10 marks) 4 (b) Describe conflict serializability and view serializability with example.(10 marks) 5 (a) Explain database system architecture in detail.(10 marks) 5 (b) What do you mean by Data Modelling? Discuss different types of Models.(10 marks)

Write short notes on:

6 (a) ACID Properties(5 marks) 6 (b) Steps in Query Processing.(5 marks) 6 (c) Data Control Command in SQL(5 marks) 6 (d) Security in Database.(5 marks)