B.Sc. (Data Science) Database Management System Syllabus - Mumbai University
This is the FY BSc Data Science 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 & DBMS Architecture: What is Database? Need of database, Role and Advantages of the DBMS, Types of Databases, Data Processing, Database Systems 2. Data Models: Data Modelling and Data Models, The Importance of Data Models, Data Model Basic Building Blocks, Business Rules, Degrees of Data Abstraction 3. Entity Relationship Model and Unified Modelling Language: Relationships, Connectivity and Cardinality, Existence Dependence, Relationship Strength, Weak Entities, Relationship Degree, Recursive Relationships, Associative (Composite) Entities, Developing an ER Diagram. 4. Advanced Data Modelling: The Extended Entity Relationship Model, Entity Clustering, Entity Integrity: Primary Keys, Design Cases: Learning Flexible Database Design.
Module II
- 1. Normalization of Database Tables: Database Tables and Normalization, The Normalization Process, Surrogate Key Considerations, Higher-Level Normal Forms, Normalization and Database Design, Denormalization, Data-modelling Checklist. 2. Database Design: The Information System, The Systems Development Life Cycle, The Database Life Cycle, Conceptual Design, DBMS Software Selection, Logical Design, Physical Design, Database Design Strategies, Centralized versus Decentralized Design 3. Transaction Management and Concurrency Control: What Is a Transaction? Concurrency Control with Locking Methods, Concurrency Control with Time Stamping Methods, Concurrency Control with Optimistic Methods, ANSI Levels of Transaction Isolation, Database Recovery Management Database Performance Tuning and Query Optimization: Database Performance-Tuning Concepts, Query Processing, Indexes and Query Optimization, Optimizer Choices, SQL Performance Tuning, Query Formulation, DBMS Performance Tuning. 4. Database Administration and Security: Data as a Corporate Asset, The Need for a Database and Its Role in an Organization, Special Considerations, Security, Database Administration Tools, Data Administration Strategy, The DBA’s Role in the Cloud, The DBA at Work: Using Oracle for Database Administration 10, 11 Reference and Text Books 1. Fundamentals of Database Systems, Elmasri Ramez and Navathe Shamkant B, Pearson Education 6th Edition, 2010. 2. Database System Concepts Silberschatz, Korth, Sudarshan, McGraw Hill, 5 Edition, 2006. 3. Database Management Systems, Ramakrishna, Gehrke, McGraw‐ Hill, 2007 4. Murach’s MySQL Joel Murach, Murach, 2012. 12 Internal Continuous Semester End Examination: 60% Assessment: 40% 13 Continuous Evaluation Format of Question Paper: External through: Examination (30 Marks)– 1 hr duration Class test of 1 of 15 marks Class test of 2 of 15 marks Average of the two: 15 marks Quizzes/ Presentations/ Assignments: 5 marks Total: 20 marks 14 Format of Question Paper: (Semester End Examination : 30 Marks. Duration:1 hour) Q1: Attempt any two (out of four) from Module 1 (15 marks) Q2: Attempt any two (out of four) from Module 2 (15 marks)
Reproduced from the University of Mumbai syllabus for B.Sc. (Data Science) 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.