Mumbai University · Second Year Information Technology · NEP 2020
Database Management System & Application
2343113 · Semester III · 3 credits · Internal tests 40 + end-semester 60
End-semester paper (2 hours): Six questions of 15 marks; Q1 is compulsory and you answer four.
Module 1: Database System Concepts and Applications
5 hoursCharacteristics of databases; file systems versus databases; data abstraction and independence; DBMS architecture; the DBA and their role; applications in banking, e-commerce, healthcare and more.
Examined in one of the two internal tests and in the 60-mark end-semester paper
- DBMS versus file processing systems
- Data abstraction and data independence
- DBMS architecture and database languages
- Role of the database administrator
Module 2: The Entity–Relationship Model
5 hoursConceptual modelling; entities, attributes, keys and relationships; weak entities; generalisation, specialisation and aggregation; the EER model.
Examined in one of the two internal tests and in the 60-mark end-semester paper
- ER model and ER diagrams
- EER model and mapping to tables
Module 3: Relational Model and Relational Algebra
5 hoursRelational constraints and schemas; primary, secondary and foreign keys; mapping ER and EER models to relations; unary, set and binary relational algebra operations and queries.
Examined in one of the two internal tests and in the 60-mark end-semester paper
- Relational model concepts and constraints
- Keys and constraints
- Relational algebra
Module 4: SQL and Indexing
8 hoursDDL, DML and DCL; set operations, aggregates and nulls; GROUP BY; recursive and nested queries; integrity constraints; JDBC; GRANT and REVOKE; functions, procedures and cursors; ordered indices.
Examined in one of the two internal tests and in the 60-mark end-semester paper
- SQL DDL and constraints
- SQL DML and SELECT queries
- Aggregate functions, GROUP BY and HAVING
- Subqueries and set operations
- Recursive queries
- Database programming with JDBC
- GRANT and REVOKE
- Stored procedures, functions and triggers
- PL/SQL blocks and cursors
- Views and indexes
Module 5: Relational Database Design
7 hoursDesign guidelines; functional dependencies; the need for and process of normalisation; 1NF, 2NF, 3NF and BCNF.
Examined in one of the two internal tests and in the 60-mark end-semester paper
- Data redundancy and anomalies
- Functional dependencies
- Normal forms: 1NF, 2NF and 3NF
- Boyce–Codd normal form
Module 6: Transactions, Concurrency and Recovery
7 hoursTransaction states and ACID; concurrent executions; conflict and view serialisability; lock-based and timestamp protocols; deadlock handling; log-based recovery.
Examined in one of the two internal tests and in the 60-mark end-semester paper
- Transactions and ACID properties
- Schedules and serializability
- Lock-based protocols and two-phase locking
- Timestamp and validation protocols
- Deadlocks in databases
- Recovery: logs, checkpoints and shadow paging
Module contents are summarised from the official Mumbai University syllabus . AiCanCode.org is not affiliated with the University of Mumbai.