B.E. (Artificial Intelligence and Data Science) Database Management System Lab Syllabus - Mumbai University
This is the SY BE AI and DS syllabus under NEP 2020, in force from the academic year 2025-26. The third and fourth years of this degree are still taught on the earlier CBCS REV-2019 'C' Scheme, because the University has published no NEP syllabus for Semesters V to VIII of any engineering branch.
Loading syllabus...
Syllabus for Database Management System Lab
Module 1 02 hours
- Identify the case study and detail statement of problem. Design an Entity-Relationship (ER) / Extended Entity-Relationship (EER) Model.
Module 2 02 hours
- Mapping ER/EER to Relational schema model.
Module 3 02 hours
- Create a database using Data Definition Language (DDL) and apply integrity constraints for the specified System
Module 4 02 hours
- Apply DML Commands for the specified system
Module 5 02 hours
- Perform Simple queries, string manipulation operations and aggregate functions.
Module 6 02 hours
- Implement various Join operations.
Module 7 04 hours
- Perform Nested and Complex queries
Module 8 02 hours
- Perform DCL and TCL commands
Module 9 02 hours
- Implement procedure and functions
Module 10 02 hours
- Implementation of Views and Triggers.
Module 11 02 hours
- Implementation and demonstration of Transaction and Concurrency control techniques using locks.
Module 12 02 hours
- Mini project (Design simple GUI and Backend Connectivity)
Reproduced from the University of Mumbai syllabus for B.E. (Artificial Intelligence and Data Science), item 6.20 (N), under NEP 2020, in force from the academic year 2025-26. Wording, module numbering and hours are as printed in that syllabus.
The complete syllabus
This subject is cut from the University circular for its year. Open a document here if you want the whole thing rather than a single subject.