Database Management Systems - Dec 2016

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) Give the advantages of DBMS over File Processing Systems.(5 marks) 1(b) What are the steps involved in Query Processing.(5 marks) 1(c) Explain Shadow Paging in brief(5 marks) 1(d) Define Super Key and Candiate Key with an example.(5 marks) 2(a) Discuss conflict serializability and view serializability with examples.(10 marks) 2(b) Describe the overall architecture of DBMS with suitable diagram.(10 marks) 3(a) Explain the following Relational Algebra Operations with example:
i) Natural Join ii) Union iii) Project iv) Select(10 marks) 3(b) Explain types of integrity constraints with example.(10 marks) 4(a) What is Normalization? Explain INF, 2NF, 3NF an J BCNF giving examples.(10 marks) 4(b) Consider the following database schema:
Employee(employee_name, street, city, date of join)
Works(employee_name, company_name, salary)
Company (compnay_name, city)
Manages(employee_name, manager_name)
Solve the following queries using SQL:
i) Give all employee of ABC Company a 25% rise.
ii) Find all employees who live in the same cities and on the same street as their managers
iii) Find all employees who join in the month of April.
iv) Delete the Smith belonging to XYZ Company.(10 marks) 5(a) What is an attribute? Discuss various types of attributes with examples.(10 marks) 5(b) Expalin Security and Authorization in DBMS.(10 marks) 6(a) Write short notes on: Total and Independance(5 marks) 6(b) Data Independence(5 marks) 6(c) ACID Properties(5 marks) 6(d) Aggregate Functions in SQL(5 marks)