MU Information Technology (Semester 3)
Database Management Systems
December 2015
Total marks: --
Total time: --
(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) What is database? Explain with examples. Also list the advantages of a database system.
5 M
1 (b) Compare ER and EER models.
5 M
1 (c) Describe ACID properties.
5 M
1 (d) Write a note on views in SQL.
5 M

2 (a) Draw an ER diagram for the education database that contains the information about an in-house company education training scheme. The relevant relations are:
Course (course-no, title)
Offering (course-no, off-no, off-date, location)
Teacher (course-no, off-no, emp-no)
Enrolment (course-no, off-no, stub-no, grade)
Employee (emp-no, emp-name, job)
Student (stub-no, stub-name, ph-no)
10 M
2 (b) Refer education database mentioned in 2(a), wire SQL queries for the following.
i) List all the teachers who conduct the course titled 'Database Systems'
ii) List all courses offered in 'Thane' on 15/8/15
iii) Find the course/s enrolled by 'Monali'.
iv) List all teh employees who work as Teachers.
10 M

3 (a) Discuss what is meant by each of the following terms (any two):
i) Database Authorization
ii) Referential Integrity
iii) Trigger
10 M
3 (b) Describe concurrency control based on timestamp ordering.
10 M

4 (a) Describe the Shadow Paging recovery technique.
10 M
4 (b) Describe the following Relational Algebra operations.
i) Select
ii) Project
iii) Natural Join
iv) Set Intersection
10 M

5 (a) Describe BCNF and 4NF in detail.
10 M
5 (b) What is system catalog or metadata? Explain.
10 M

Write a short note on ( any two).
6 (a) Query Optimization.
10 M
6 (b) Relational Calculus
10 M
6 (c) Deadlock handling.
10 M

More question papers from Database Management Systems