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.
Module 1: Databases and Data Modelling
8 hoursDatabase 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
Module 2: Relational Model and Relational Algebra
5 hoursRelational 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
- The relational model and Codd's rules
- Keys in the relational model
- Relational algebra
Module 3: Structured Query Language
10 hoursDDL; 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
Module 4: Normalisation
5 hoursPitfalls 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
- Functional dependencies
- Normalisation: 1NF, 2NF, 3NF and BCNF
- Fourth normal form and multivalued dependencies
Module 5: Transactions and Concurrency Control
7 hoursTransaction 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
- Transactions and ACID properties
- Schedules and serialisability
- Concurrency control and locking
- Timestamp-based protocols
- Log-based recovery
- Deadlock handling in databases
Module 6: Modern Databases
4 hoursIndustry 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
- Cloud and distributed databases
- NoSQL data models
- Object-oriented databases
Module contents are summarised from the official Mumbai University syllabus . AiCanCode.org is not affiliated with the University of Mumbai.