MU Computer Engineering (Semester 5)
Advanced Database Mgmt System
December 2014
Total marks: --
Total time: --
INSTRUCTIONS
(1) Assume appropriate data and state your reasons
(2) Marks are given to the right of every question
(3) Draw neat diagrams wherever necessary


1 (a) Explain in details working of hash join.
10 M
1 (b) Discuss the database design and implementation process with suitable diagram.
10 M

2 (a) Discuss the steps of mapping of EER schemes into relational model.
10 M
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 M

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 M
3 (b) Explain the concept of specialization and generalization with example.
10 M

4 (a) Explain in details goals and approaches of Query optimization.
10 M
4 (b) Discuss following technique of data partitioning.
i) Round Robin partitioning
ii) Range partitioning
10 M

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 M
5 (b) Explain query processing technique DBMS with suitable diagram.
10 M

6 (a) Explain tin details various approaches of query evaluation.
10 M
6 (b) Explain following with example.
i) Structured data
ii) Semi-Structured data.
10 M

Write a short notes on:
7 (a) Exist and NOT EXIST
5 M
7 (b) XML scheme features
5 M
7 (c) Three-Tier Architecture
5 M
7 (d) Two Phase Commit Protocol
5 M



More question papers from Advanced Database Mgmt System
SPONSORED ADVERTISEMENTS