Database Management System - Jun 2014

Computer Engineering (Semester 3)

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. 1 (a) Explain disadvantage of conventional file-based system compared to Database management system.(7 marks) 1 (b) Explain Entity Relationship model with example.(7 marks) 2 (a) Write a short note on Relational algebra.(7 marks) 2 (b) What are integrity constraints? Explain various type of integrity constraints with suitable example.(7 marks) 2 (c) Explain three level architecture of DBMS.(7 marks) 3 (a) What is normalization ? Why normalization process is needed? Explain 1 NF, 2NF and 3 NF with example.(7 marks) 3 (b) What is deadlock ? Explain deadlock detection and prevention policies.(7 marks) 3 (c) Explain conflict serializability and view serializability.(7 marks) 3 (d) What is decomposition? Why is it required? Explain the difference between lossy decomposition and non-loss decomposition with example.(7 marks) 4 (a) Write short note on query processing.(7 marks) 4 (b) Explain log-based recovery and shadow paging technique.(7 marks) 4 (c) Explain different types of outer join with example.(7 marks) 4 (d) Explain time stamp based protocols.(7 marks) 5 (a) Write A PL/SQL block to print the sum of Numbers from 1 to 20.(7 marks) 5 (b) Explain DDL, DML and DCL syntaxes with example.(7 marks) 5 (c) Write A PL/SQL block to print the given number is Odd or Even.(7 marks) 5 (d) Explain Aggregate, Date and String function with example.(7 marks)