Question Paper: Database Management System Question Paper - May 16 - Computer Engineering (Semester 5) - Mumbai University (MU)
Database Management System - May 16 (Old Syllabus 2012)
Computer Engineering (Semester 5)
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) Explain BCNF with example.
1(b) Write short note on Deadlocks.
1(c) Explain Total and partial Participation.
1(d) Discuss the role of Database Administrator.
2(a) Discuss steps in query processing. Also describe cost based query optimization.
2(b) Draw an ER Diagram and convert it into relational model for a Company, which has several Employees working on different types of projects. Several Employees are working for one Department every Department has a Manager. Several Employees are supervised by one Employee.
3(a) Explain types of integrity constraints with example.
3(b) Discuss Data definition and Manipulation Commands in SQL.
4(a) Describe the overall architecture of DBMS with suitable diagram.
4(b) Explain Security and Authorization in DBMS.
5(a) Explain the following Relational Algebra Operations with example: i. Natural Join 645
ii. Set Intersection iii. Generalized Projection 642