UNIVERSITY OF MADRAS
B.Sc. DEGREE COURSE IN COMPUTER SCIENCE
SYLLABUS WITH EFFECT FROM 2020-2021
BCE-CSC11
CORE: RELATIONAL DATABASE MANAGEMENT SYSTEM
(Common paper to B.Sc.Software Applications, B.Sc.Computer Science with
Data Science, Computer Science with AI & B.C.A.)
II / III YEAR
III / V SEM
OBJECTIVES:
Gain a good understanding of the architecture and functioning of Database Management Systems
Understand the use of Structured Query Language (SQL) and its syntax.
Apply Normalization techniques to normalize a database.
Understand the need of transaction processing and learn techniques for controlling the
consequences of concurrent data access.
OUTCOMES:
Describe basic concepts of database system
Design a Data model and Schemas in RDBMS
Competent in use of SQL
Analyze functional dependencies for designing robust Database
UNIT - I
Introduction to DBMS– Data and Information - Database – Database Management System – Objectives
- Advantages – Components - Architecture. ER Model: Building blocks of ER Diagram –
Relationship Degree – Classification – ER diagram to Tables – ISA relationship – Constraints –
Aggregation and Composition – Advantages
UNIT - II
Relational Model: CODD’s Rule- Relational Data Model - Key - Integrity – Relational Algebra
Operations – Advantages and limitations – Relational Calculus – Domain Relational Calculus -
QBE.
UNIT - III
Structure of Relational Database. Introduction to Relational Database Design - Objectives – Tools –
Redundancy and Data Anomaly – Functional Dependency - Normalization – 1NF – 2NF – 3NF –
BCNF. Transaction Processing – Database Security.
UNIT - IV
SQL: Commands – Data types – DDL - Selection, Projection, Join and Set Operations – Aggregate
Functions – DML – Modification - Truncation - Constraints – Subquery.
UNIT - V
PL/SQL: Structure - Elements – Operators Precedence – Control Structure – Iterative Control -
Cursors - Procedure - Function - Packages – Exceptional Handling - Triggers.
UNIVERSITY OF MADRAS
B.Sc. DEGREE COURSE IN COMPUTER SCIENCE
SYLLABUS WITH EFFECT FROM 2020-2021
TEXT BOOK:
1. S. Sumathi, S. Esakkirajan, “Fundamentals of Relational Database Management System”,
Springer International Edition 2007.
REFERENCE BOOKS:
1. Abraham Silberchatz, Henry F. Korth, S. Sudarshan, “Database System Concepts”, McGrawHill
2019, 7th Edition.
2. Alexis Leon & Mathews Leon, “Fundamentals of DBMS”, Vijay Nicole Publications 2014, 2nd
Edition.
WEB REFERENCES:
NPTEL & MOOC courses titled Relational Database Management Systems
https://nptel.ac.in/courses/106106093/
https://nptel.ac.in/courses/106106095/
