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 following Relational Algebra operations with suitable example. 10 marks
  2. Q3 Union 4) Rename
  3. 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.

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!