Computer Engineering Sem 4 Database Management System Question Paper PDF 2026 - Mumbai University | munotes
Loading PDF...
Questions asked in this paper
-
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
-
Q1 Project 2) Select
-
Q3 Union 4) Rename
-
Q5 Set difference 4 Consider the following employee database. [10] Employee (empname, street, city, date_of_joining) Write SQL queries for the following statements
-
Q1 Modify the database so that ‘John’ now lives in ‘Mumbai’
-
Q2 Find all employees who joined in the month of October
-
Q3 Give all employees of ‘ABC Corporation’ a 10% raise
-
Q4 Find all employees who earn more than average salary of all employees of their company
-
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.
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.
Quick Help
Related Resources
Something wrong with this paper? Report it.