School of Engineering & Technology

Course Outline
Course Title: Database Management Systems Course Code: 23BCS-0DB22C
Academic Year: 2025-
Semester: Btech CSE IV Core/Elective: Core LTP:3-0-2 Credits: 4
2026
Course Designed by: Dr Sherry Verma Course Instructor: Dr Sherry Verma
e-mail: sherryverma@[Link] e-mail: sherryverma@[Link]
Pre-requisites: None

1. Course Outcomes: Upon successful completion of the course, the student should be able to

CO1: Understand and Explain the fundamental concepts of database management systems, including
DBMS architecture, data models, schemas, and data independence.
CO2: Apply ER and EER modeling concepts to design database schemas and Construct ER model.
Design relational model from ER model.
CO3: Implement relational model using SQL and Execute queries using SQL and relational algebra.
CO4: Describe pitfalls of bad schema design and normalize the schema to overcome it.
CO5: Evaluate which non serial schedule running concurrently are efficient enough to keep database in a
consistent state by applying the concept of conflict as well as view Serializability of transaction, lock
based, timestamp-based concurrency protocol and how to recover from various hardware and
software failures.

2. Program Outcomes:

This section deals with how well this course meets the following eight overall program outcomes (POs):
PO1: Engineering knowledge: Apply the knowledge of mathematics, science, engineering fundamentals, and
engineering. Specialization to the solution of complex engineering problems.
PO2. Problem analysis: Identify, formulate, research literature, and analyze engineering problems to arrive at
substantiated conclusions using first principles of mathematics, natural, and engineering sciences.
PO3. Design/development of solutions: Design solutions for complex engineering problems and design system
components, processes to meet the specifications with consideration for the public health and safety, and the
cultural, societal, and environmental considerations.
PO4. Conduct investigations of complex problems: Use research-based knowledge including design of
experiments, analysis and interpretation of data, and synthesis of the information to provide valid conclusions.
PO5. Modern tool usage: Create, select, and apply appropriate techniques, resources, and modern engineering
and modeling to complex engineering activities with an understanding of the limitations.
PO6. The engineer and society: Apply reasoning informed by the contextual knowledge to assess societal,
health, safety, legal, and cultural issues and the consequent responsibilities relevant to the professional
engineering practice.
PO7. Environment and sustainability: Understand the impact of the professional engineering solutions in
societal and environmental contexts, and demonstrate the knowledge of, and need for sustainable development.
PO8. Ethics: Apply ethical principles and commit to professional ethics and responsibilities and norms of the
engineering practice.
PO9. Individual and team work: Function effectively as an individual, and as a member or leader in teams, and
in multidisciplinary settings.
PO10. Communication: Communicate effectively with the engineering community and with society at large. Be
able to comprehend and write effective reports documentation. Make effective presentations, and give and receive
clear instructions.
PO11. Project management and finance: Demonstrate knowledge and understanding of engineering and
management principles and apply these to one’s own work, as a member and leader in a team. Manage projects
in multidisciplinary environments.
 PO12. Life-long learning: Recognize the need for, and have the preparation and ability to engage in independent
and life-long learning in the broadest context of technological change.

Programme Specific Outcomes - On completion of the [Link]..(Computer Science and Engineering) degree the
graduates will be able to

PSO1: Apply standard Software Engineering practices and strategies in real-time software project development
using open-source programming environment or commercial environment to deliver quality product for the
organization success
PSO2: Design and develop computer programs/computer-based systems in the areas related to algorithms,
networking, web design, cloud computing, IoT and data analytics of varying complexity
PSO3: Acquaint with the contemporary trends in industrial/research settings and thereby innovate novel solutions
to existing problems

3. CO-PO Mapping (Course Outcome and Programme Outcome Mapping)

PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PO11 PO12 PSO1 PSO2 PSO3
CO1 H H H L L L M M H H H H L M M
CO2 H H H M M M M M M L L L M M H
CO3 L L L H H H M M H H H H H H H

4. Syllabus : Total Hrs. : 42

Unit-I Lecture Hr. : 6

Basic Concepts-Database System and its Applications, Database administrator & Database Users, Workers
behind the scene, Characteristics of the Database Approach, Advantages of using the DBMS Approach. Data
Models, Schemes & Instances, three schema architecture, view of data & Data Independence, Centralized and Client-
Server Architectures for DBMS.
Unit-II Lecture Hr.: 6
Data Modeling Using the Entity-Relationship Model – Entities, Attributes and Relationships, Cardinality of
Relationships, Participation constraint, Strong and Weak Entity Sets, Generalization, Specialization, and
aggregation in EER, constructing EER diagrams.
Unit-III Lecture Hr.: 12
Relational Model: Relational Model Concepts, Relational Model Constraints, Relational algebra,
translating ER Model into Relational Model, SQL – A Relational Database Language, DDL-DML-DCL in
SQL, View and Queries in SQL, Specifying Constraints and Indexes in SQL, aggregate function in SQL, joins
in SQL, nested queries.
Unit IV Lecture Hr.: 8
Relational Data Base Design: Introduction, Functional Dependencies, Normalization for Relational Databases,
Normal Forms Based on Primary Key (1NF, 2NF, 3NF, BCNF), Lossless Join and Dependency Preserving
decomposition.
Unit V Lecture Hr.: 10
Transaction Management: Introduction to transaction processing, Transaction Concept and State, desirable
properties of transactions, Serializability, Recoverability, transaction support in SQL. Concurrency Control:
Lock-Based Protocols, Timestamp-based Protocols, Deadlock Handling. Recovery System, Failure
classification, Log-based Recovery

1. Text Book:
T1: Avi Silberschatz , Henry F. Korth , S. Sudarshan : Database System Concepts, 6th Edn, 2015
T2: Elmsari , Navathe: Fundamentals of Database Systems , 7th Edn, 2016

2. Reference Book(s):
R1: Raghu Ramakrishnan and Johannes Gehrke : Database Management Systems, 2007
R2: C.J. Date : An Introduction to Database Systems, 2012
R4: Graeme Simsion and Graham Witt: Data Modeling Essentials, 3rd Edition , 2004
 R5: Ramon Mata-Toledo : Schaum's Outline of Fundamentals of Relational Databases, 2000
R6: Bipin C. Desai : Introduction to Database Management Systems, 1997.
R7: Alex Kriegel , Boris M. Trukhnov : SQL Bible , 2008.
R8: Mark L. Gillenson : Fundamentals of Database Management Systems, 2008.

3. Evaluation Scheme

Exam Type Marks Breakup

Mid Semester Evaluation (40)
Theory (30) Lab (10)
Mid Semester Examination 15 Mid Semester 5
Examination
Quiz/Presentation/Assignment 15 Lab/Practical 5
Performed/Lab
Report
End Semester Examination (60)
Theory (40) Lab (20)