B.Sc. (Information Technology) Database Management System Syllabus - Mumbai University
This is the FY BSc IT syllabus under NEP 2020, in force from the academic year 2024-25. The University still sets the earlier Choice Based papers alongside it for ATKT candidates, so check which scheme your exam form names before you revise.
Loading syllabus...
Syllabus for Database Management System
Module I
- 1. Introduction to Databases and transactions What is database system, purpose of database system, view of data, relational databases, database architecture, transaction management 2. Data Models The importance of data models, Basic building blocks, Business rules, The evolution of data models, Degrees of data abstraction 3. Database Design, ER-Diagram Database design and ER Model: overview, ER-Model, Constraints, ER-Diagrams, ERD Issues, Codd’s rules, Relational Schemas 4. Relational database model Logical view of data, keys, integrity rules
Module II
- 1. Database Design theory and normalization: Basics of functional dependencies and normalization for relational databases. Relational database design and further dependencies. 2. SQL, Indexing: Introduction to SQL, Complex queries, triggers, views, joining database tables and schema modification. Query Processing and . optimization. File structure, hashing and indexing 3. Transaction management and concurrency control and recovery: Introduction to transaction processing concepts and theory. Concurrency control technique. Database recovery technique
Text Books
- 1 “Fundamentals of Database System”, Elmasri Ramez, Navathe Shamkant, Pearson Education, Seventh edition, 2017
- 2 Database Management Systems”, Raghu Ramakrishnan and Johannes Gehrke, 3rd Edition, 2014
- 3 Database Systems: Design implementation and management by Carlos Coronel, Steven Morris, Peter Rob
- 1 “Database System Concepts”, Abraham Silberschatz, Henry F. Korth, S. Sudarshan, McGraw Hill, 2017
- 2 “MySQL: The Complete Reference”, Vikram Vaswani , McGraw Hill, 2017
- 3 “Learn SQL with MySQL: Retrieve and Manipulate Data Using SQL Commands with Ease”, Ashwin Pajankar, BPB Publications, 2020
Reproduced from the University of Mumbai syllabus for B.Sc. (Information Technology) under NEP 2020, in force from the academic year 2024-25. 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.
Use FYBSc IT, SYBSc IT, or TYBSc IT first so your syllabus check matches the semester you are preparing for.
Use the syllabus to confirm topics, then open BSc IT notes for the same semester.
Move to BSc IT question papers after reviewing the module scope.