Syllabus (COMPUTER SCIENCE)

Course Type: ME-7

Semester: 7

Course Code: BCOSMEB47C

Course Title: Database Management Systems

(L-P-Tu): 3-1-0

Credit: 4

Practical/Theory: Combined

Course Objective: • Understand DBMS fundamentals for modern data management • Master efficient relational database design and management • Proficiency in SQL for data retrieval and analysis

Learning Outcome: • Explain DBMS advantages and layered architecture • Create ER models, identify entities, and enforce constraints • Design normalized databases for data integrity

Theory

Introduction

Traditional File Systems, Advantages of DBMS, Layered Architecture of DBMS, Data Independence, Data Models, Schemas and Instances. (6 Lectures)

Entity-Relationship Model

Entities, Attributes, Relationships, Integrity Constraints, Keys, ER Diagrams. (8 Lectures)

Relational Model

Basic Concepts of a Relational Model, Introduction to Relational Algebra. (7 Lectures)

Relational Database Design

Functional Dependencies, Armstrong’s Axioms, Closure of FD Sets, Relational Decomposition, Lossless Decomposition, Dependency Preservation, Database Anomalies,Normalization, 1NF, 2NF, 3NF, BCNF. (14 Lectures)

SQL

Basic Structure, DDL, DML, Basic SQL Queries, Aggregate Functions, Joins. (10 Lectures)

DBMS Lab

Creating and managing databases, querying data, and performing basic data analysis using SQL

Reading References

1. R. Elmasri, S.B. Navathe,Fundamentals of Database Systems, Pearson Education
2. R. Ramakrishnan, J. Gehrke, Database Management Systems, McGraw-Hill
3. A. Silberschatz, H.F. Korth, S. Sudarshan, Database System Concepts, McGraw Hill
4. R. Elmasri, S.B. Navathe, Database Systems Models, Languages, Design and Application Programming, Pearson Education