Mumbai University SE Computer syllabus

Mumbai University · Second Year Computer Engineering · NEP 2020

Database Management System

2114112 · Semester IV · 3 credits · Internal tests 40 + end-semester 60

End-semester paper (2 hours): Six questions of 20 marks; Q1 is compulsory and you answer three.

All notes for this subject
  1. Module 1: Databases and Data Modelling

    8 hours

    Database characteristics and applications; DBMS architecture; ACID properties; the ER model: strong and weak entities, attributes, keys, cardinality and participation; EER: generalisation, specialisation and aggregation.

    Examined in one of the two internal tests and in the 60-mark end-semester paper

  2. Module 2: Relational Model and Relational Algebra

    5 hours

    Relational schema and keys; mapping ER and EER to relations; selection, projection, union, difference, product, join, intersection and rename; relational algebra queries.

    Examined in one of the two internal tests and in the 60-mark end-semester paper

  3. Module 3: Structured Query Language

    10 hours

    DDL; key, domain, referential and check constraints; DML, DCL and TCL; aggregates with GROUP BY and HAVING; joins; nested queries; views; set and string operations; triggers; PL/SQL blocks.

    Examined in one of the two internal tests and in the 60-mark end-semester paper

  4. Module 4: Normalisation

    5 hours

    Pitfalls in relational design; functional dependencies and their closure; 1NF, 2NF, 3NF, BCNF and 4NF.

    Examined in one of the two internal tests and in the 60-mark end-semester paper

  5. Module 5: Transactions and Concurrency Control

    7 hours

    Transaction states; concurrent executions; conflict and view serialisability; lock-based and timestamp protocols; log-based recovery; deadlock handling.

    Examined in one of the two internal tests and in the 60-mark end-semester paper

  6. Module 6: Modern Databases

    4 hours

    Industry trends; cloud and distributed databases; NoSQL and object-oriented databases.

    Examined in one of the two internal tests and in the 60-mark end-semester paper

Module contents are summarised from the official Mumbai University syllabus . AiCanCode.org is not affiliated with the University of Mumbai.