Question Paper: Database Management System Question Paper - Dec 17 - Computer Engineering (Semester 5) - Mumbai University (MU)

Database Management System - Dec 17 (Old Syllabus 2012)

Computer Engineering (Semester 5)

Total marks: 80
Total time: 3 Hours
(1) Question No. 1 is compulsory
(2) Solve any three questions out of remaining questions
(3) Draw neat diagrams wherever necessary

1(a) Describe Data Independence.
(5 marks) 00

1(b) Compare File System and Database System.
(5 marks) 634

1(c) Explain ACID properties.
(5 marks) 654

1(d) Explain Aggregate Functions in SQL.
(5 marks) 648

2(a) Define Normalization. Discuss different Normalization Techniques with example.
(10 marks) 651

2(b) Describe the overall architecture of DBMS with suitable diagram.
(10 marks) 638

3(a) Explain types of integrity constraints with example.
(10 marks) 00

3(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.
(10 marks) 00

4(a) Discuss Data Definition and Manipulation Commands in SQL.
(10 marks) 653

4(b) Explain Security and Authorization in DBMS.
(10 marks) 00

5(a) Explain the following Relational Algebra Operations with example:

  • (i) Cartesian product
  • (ii) Project
  • (iii) Natural Join
  • (iv) Union
(10 marks) 00

5(b) Explain Log based recovery and shadow paging in detail.
(10 marks) 664

Q6) Write short notes on:

  • (a) Steps in Query processing
  • (b) Role of Database Administrator 635

  • (c) Deadlocks 662

  • (d) Specialization and Aggregation 642

(20 marks)

modified 6 months ago by gravatar for Sanket Shingote Sanket Shingote ♦♦ 250 written 7 months ago by gravatar for Yashbeer Yashbeer ♦♦ 130
Please log in to add an answer.