B.E. (Automation and Robotics) DataBase Management Systems Syllabus - Mumbai University 2026
The University has moved this degree onto NEP 2020 one year at a time. The first and second years are NEP 2020 syllabi; the third and fourth years are still examined on the REV-2019 'C' Scheme, which is what the University sets for them this year.
Loading syllabus...
Syllabus for DataBase Management Systems
Module 1: Introduction Database Concepts: Introduction, Characteristics of databases, File system V/s Database system, Users of Database system, Concerns when using an enterprise database, Data Independence, DBMS system architecture, Database Administrator
- Entity–Relationship Data Model : Introduction, Benefits of Data Modeling, Types of Models, Phases of Database Modeling, The Entity-Relationship (ER) Model, Generalization, Specialization and Aggregation, Extended Entity-Relationship (EER) Model.
Module 2
- Relational Model and Algebra : Introduction , Mapping the ER and EER Model to the Relational Model , Data Manipulation , Data Integrity ,Advantages of the Relational Model, Relational Algebra , Relational Algebra Queries, Relational Calculus.
Module 3
- Structured Query Language (SQL) : Overview of SQL , Data Definition Commands, Set operations , aggregate function , null values, , Data Manipulation commands, Data Control commands , Views in SQL, Nested and complex queries .
Module 4
- Integrity and Security in Database: Domain Constraints, Referential integrity, Assertions, Trigger, Security, and authorization in SQL Relational–Database Design : Design guidelines for relational schema, Function dependencies, Normal Forms- 1NF, 2 NF, 3NF, BCNF and 4NF
Module 5: Transactions Management and Concurrency: Transaction concept, Transaction states, ACID properties, Implementation of atomicity and durability, Concurrent Executions, Serializability, Recoverability, Implementation of isolation, Concurrency Control: Lock-based , Timestamp based , Validation-based protocols, Deadlock handling, Recovery System:
- Failure Classification, Storage structure, Recovery & atomicity, Log based recovery, Shadow paging.
Module 6: Query Processing and Optimization: Overview ,Issues in Query Optimization ,Steps in Query Processing , System Catalog or Metadata, Query Parsing , Query Optimization, Access Paths , Query Code Generation , Query Execution, Algorithms for Computing Selection and Projection , Algorithms for Computing a Join , Computing Aggregation Functions , Cost Based Query
- Optimization .
Text Books
- 1 G. K. Gupta :”Database Management Systems”, McGraw – Hill.
- 2 Korth, Slberchatz,Sudarshan, :”Database System Concepts”, 6th Edition, McGraw – Hill
- 3 Elmasri and Navathe, “ Fundamentals of Database Systems”, 5thEdition, PEARSON Education.
- 4 Peter Rob and Carlos Coronel, “ Database Systems Design, Implementation and Management”, Thomson Learning, 5th Edition.
- 1 Dr. P.S. Deshpande, SQL and PL/SQL for Oracle 10g,Black Book, Dreamtech Press Mark L. Gillenson, Paulraj Ponniah, “ Introduction to Database Management”,Wiley
- 2 Sharaman Shah ,”Oracle for Professional”, SPD.
- 3 Raghu Ramkrishnan and Johannes Gehrke, “ Database Management Systems”,TMH
- 4 Debabrata Sahoo “Database Management Systems” Tata McGraw Hill, Schaum’s Outline 48
Reproduced from the University of Mumbai syllabus for B.E. (Automation and Robotics) under REV-2019 'C' Scheme, in force from the academic year 2023-24. Wording is as printed in that syllabus. Module numbering is as printed there too.
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.