munotes®

Computer Engineering Sem 4 Database Management System Question Paper PDF 2026 - Mumbai University | munotes

Computer Engineering Sem 4 Database Management System Question Paper.pdf
CMPN · 1 May 2025

Loading PDF...

Questions asked in this paper

  1. Q1 Explain the concept of First Normal Form (1NF).Give example for the same. e Discuss conflict serializability with suitable example. [5] 2 a_ Describe the overall architecture of DBMS with suitable diagram [10] b What is deadlock? Explain wait-die and wound-wait methods with suitable [10] 3 a Draw an E-R diagram for library management system. Convert it into relational the following Relational Algebra operations with suitable example. [10] 5 marks
  2. Q1 Project 2) Select
  3. Q3 Union 4) Rename
  4. Q5 Set difference 4 Consider the following employee database. [10] Employee (empname, street, city, date_of_joining) Write SQL queries for the following statements
  5. Q1 Modify the database so that ‘John’ now lives in ‘Mumbai’
  6. Q2 Find all employees who joined in the month of October
  7. Q3 Give all employees of ‘ABC Corporation’ a 10% raise
  8. Q4 Find all employees who earn more than average salary of all employees of their company
  9. Q5 List name of companies starting with letter “A” b Why there is need of normalization? Explain INF, 2NF, 3NF and BCNF with [10] 5 Describe ACID properties with examples [10] Explain Lock based (2PL) concurrency control method with example [10] 6 Write short note on the following(Any four) [20] a Conversion of Specialization to relational schema with suitable example [05] c Role of DBA [05] e Types of attributes [05]

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.

Computer Engineering Sem 4 Paper Path

Use this paper as one timed CMPN Sem 4 mock, then compare Operating System, Engineering Mathematics IV, DBMS, Microprocessors, and Analysis of Algorithm papers from nearby year sets.

Step: Open this Computer Engineering Sem 4 paper in the free viewer first.

Step: Compare the May 2024 and December 2022 year sets for repeated subjects.

Step: Use the full CMPN Sem 4 folder when you need more second-year engineering practice.

Open this paper

All Computer Sem 4 papers

This year set

DBMS paper

Analysis of Algorithm paper

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!