Computer Engineering Sem 4 Database Management System Question Paper PDF 2026 - Mumbai University | munotes
Loading PDF...
Questions asked in this paper
-
Q1 Explain the following Relational Algebra operations with suitable example. 10 marks
-
Q3 Union 4) Rename
-
Q5 Natural Join Store(store_no, city, state, inventory_val) Stock(store_no, book_id,quantity)
- (1)Modify the cost of DBMS books by 10%
- (ii)Find the total number of books in Mumbai stores title of all books whose title contains the word ‘System’
- (iv)Find title of the most expensive book
- (v)Add a new record in Book(Assume values as per requirement) b Why there is need of normalization? Explain INF, 2NF, 3NF and BCNF with [10] 5 Describe ACID properties with examples [10] b Give example of serial schedule and equivalent to serial schedule with respect to [10] conflict serailizability. Discuss conflict serializability with example 6 Write short note on the following (Any four) [20] a Conversion of Specialization to relational schema with suitable example [05] 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.