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.
What should we fix or add?
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.