B.Sc. (Computer Science) Fundamentals of Database Systems Syllabus - Mumbai University
This is the FY BSc Computer Science syllabus under NEP 2020, in force from the academic year 2024-25. The University still sets the earlier Choice Based papers alongside it — her Summer 2026 third-year timetables name that scheme — so check which scheme your exam form names before you revise.
Loading syllabus...
Syllabus for Fundamentals of Database Systems
The University sets the practical for this subject separately, in Computer Science Practical 1, as Module 2. It carries its own credits, so it is examined as a paper of its own.
Module I
- Introduction to DBMS: Database, DBMS – Definition, Overview of DBMS, Advantages of DBMS, Levels of abstraction, Data independence, DBMS Architecture
- Data models: Client/Server Architecture, Object Based Logical Model, Record Based Logical Model (relational, hierarchical, network
- Entity Relationship Model and ER to Table: Entities, attributes, entity sets, relations, relationship sets, Additional constraints (key constraints, participation constraints, weak entities, aggregation / generalization, Conceptual Design using ER (entities VS attributes, Entity Vs relationship, binary Vs ternary, constraints beyond ER) Entity to Table, Relationship to tables with and without key constraints.
- DDL Statements: Creating Databases, Using Databases, datatypes, Creating Tables (with integrity constraints – primary key, default, check, not null), Altering Tables, Renaming Tables, Dropping Tables, Truncating Tables
- DML statements: Viewing the structure of a table insert, update, delete, Select all columns, specific columns, unique records, conditional select, in clause, between clause, limit, aggregate functions (count, min, max, avg, sum), group by clause, having clause
Module II
- Relational data model: Domains, attributes, Tuples and Relations, Relational Model Notation, Characteristics of Relations, Relational Constraints - primary key, referential integrity, unique constraint, Null constraint, Check constraint
- Functions: String Functions (concat, instr, left, right, mid, length, lcase/lower, ucase/upper, replace, strcmp, trim, ltrim, rtrim), Math Functions (abs, ceil, floor, mod, pow, sqrt, round, truncate) Date Functions(adddate, datediff, day, month, year, hour, min, sec, now, reverse)
- Joining Tables and Subqueries: inner join, outer join (left outer, right outer, full outer)
- subqueries with IN, EXISTS, subqueries restrictions, Nested subqueries, ANY/ALL clause, correlated subqueries
- Normal forms: Functional dependencies, first, second, third, and BCNF normal forms based on primary keys, lossless join decomposition.
- Database Protection: Security Issues, Threats to Databases, Security Mechanisms, Role of DBA, Discretionary Access Control, Backing Up and Restoring databases
- Views: Creating, altering dropping, renaming and manipulating views
- DCL Statements: Creating/dropping users, privileges granting/revoking privileges, viewing privileges), Transaction control commands – Commit, Rollback
Text Books
- 1 Fundamentals of Database System, ElmasriRamez, NavatheShamkant, Pearson Education, Seventh edition, 2017
- 2 Database Management Systems, Raghu Ramakrishnan and Johannes Gehrke, 3rd Edition,2014
- 3 Murach's MySQL, Joel Murach, 3rd Edition, 3rd Edition, 2019
- 1 Database System Concepts, Abraham Silberschatz, HenryF.Korth, S.Sudarshan, McGraw Hill,2017
- 2 MySQL: The Complete Reference, VikramVaswani , 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. (Computer 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.