Advanced Database Mgmt System - Dec 2014

Computer 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. 1 (a) Explain in details working of hash join.(10 marks) 1 (b) Discuss the database design and implementation process with suitable diagram.(10 marks) 2 (a) Discuss the steps of mapping of EER schemes into relational model.(10 marks) 2 (b) Explain following join operation with example.
i) Left outer join
ii) Right outer join
iii) Equi join
iv) Self join
v) Inner join(10 marks) 3 (a) Consider following relations database to perform DDL operation on it. STUDENT (Sid, Name, Address, DOB)
COURSE (Course_id, Name, Dept)

i) Create a student and course table.
ii) Insert 5 records in both tables.
iii) Delete all students records whose name are starting with 'K' letter
iv) Modify course id
v) Drop both table.(10 marks) 3 (b) Explain the concept of specialization and generalization with example.(10 marks) 4 (a) Explain in details goals and approaches of Query optimization.(10 marks) 4 (b) Discuss following technique of data partitioning.
i) Round Robin partitioning
ii) Range partitioning(10 marks) 5 (a) Consider the following relational database
Employee (Eid, name, dept, salary, DOJ)

i) Arrange all records of database department wise
ii) Display name of Employee who earn max salary in sales dept.
iii) Find out total salary paid to the employees.
iv) Display all employees list who have join before 07/12/2012.(10 marks) 5 (b) Explain query processing technique DBMS with suitable diagram.(10 marks) 6 (a) Explain tin details various approaches of query evaluation.(10 marks) 6 (b) Explain following with example.
i) Structured data
ii) Semi-Structured data.(10 marks)

Write a short notes on:

7 (a) Exist and NOT EXIST(5 marks) 7 (b) XML scheme features(5 marks) 7 (c) Three-Tier Architecture(5 marks) 7 (d) Two Phase Commit Protocol(5 marks)