munotes®

Engineering B.E. (Computer Engineering) Sem 5 Database Management System Dec 2018 Question Paper - Mumbai University | munotes

Database Management System Question Paper, Dec 2018.pdf
CMPN · 287 KB · 1 May 2025

Loading PDF...

Older exam None: this is the earliest we hold
Newer exam May 2019 Semester-end · Database Management System →

Questions asked in this paper

  1. Q2 a) Define Deadlock. Explain Deadlock Detection, Prevention and Recovery 10 marks
    • b) List 5 Significant differences between file processing system and Database 10
  2. Q3 Explain Overall Architecture of DBMS in detail 10 marks
    • b) Construct ER diagram and convert into Relational Model for Company 10 Which has several Employees working on different types of projects Several Employees are working on one department. Every Employee has Manager. Several Employees are supervised by one Employee
  3. Q4 Explain the concept of Serializability with its types 10 marks
    • b) Explain following Relational Algebra operations with suitable example 10
    • a) Project b) Select
  4. Q1 Modify database so that John now lives in Mumbai
  5. Q2 Find Employees who live in same city as the company for which
  6. Q3 Give all employees of “AZ Corporation” where there is increase in salary by
  7. Q4 Find the names of all employees, company name and city of residence such that Employee name begins with
  8. Q5 Delete all tuples in works relation for employees of small bank corporation
    • b) Define Normalization. Discuss 1NF, 2 NF and 3 NF in Detail 10
  9. Q6 Write short notes on any two 20 marks
    • a) Based Recovery
    • b) in SQL
    • c) and Generalization

Read from the scan above, so a character or two may differ. The scan is the original.

Issue

Something wrong on this page? Report it and we will check it against the scan.

Quick Help

No. The full paper opens straight away, with no login and nothing to pay.

Something wrong with this paper? Report it.

Connected Papers
Engineering / B.E. (Computer Engineering) · 250 papers
Browse all →
Questions? Email contact@munotes.in
Done!
Done!