Syllabus-2024-2025
(SOET)(BTech-ComputerScience)
Title of the Course Database Management System
Course Code CSL0311 [T]
Part A
L T P C
Year 2nd Semester 3rd Credits
3 0 1 4
Course Type Embedded theory and lab
Course Category Discipline Core
Student should be aware of the functioning of
Application software and how information
Pre-Requisite/s Co-Requisite/s
technology helps in providing information by
processing Data.
CO1- Understand basic concepts of query writing, and transaction management and
identify various data models (ER modeling concepts) for designing a good database (BL1-
Remember)
CO2- Apply relational database theory and describe relational algebra expression, tuple,
and domain relation expression for writing queries in relational algebra and SQL.(BL2-
Understand)
Course Outcomes
CO3- Analyze the quality of the database using normalization techniques, conflict scenarios
& Bloom's Level
using concurrent processing techniques, and analyze various transaction serialization
scenarios(BL3-Apply)
CO4- Evaluate and improve the database design by applying normalization, key
constraints, and other constraints.(BL4-Analyze)
CO5- Design a real database application using Database Management approaches(BL5-
Evaluate)
Skill Development ✔ SDG1(No poverty)
Entrepreneurship ✖ SDG2(Zero hunger)
Employability ✔ SDG4(Quality education)
Course Elements Professional Ethics ✖ SDG (Goals) SDG8(Decent work and economic
Gender ✖ growth)
SDG12(Responsible consuption and
Human Values ✖
production)
Environment ✖
Part B
Modules Contents Pedagogy Hours
Introduction to the Databases: Database
definitions, Databases and Traditional File
Processing, Systems, Advantages of
Databases, Functions of DBMS, Data
Models, Types of data models. Database
Architecture and Client/server architecture.
UNIT 1 Relational Data Model. E-R Model: Basic LECTURE 10
Concepts, Design Issues, Mapping
Constraints, Keys, E-R Diagram, Weak
Entity set, Extended E-R features, Design of
an E-R Database Schema, Reduction of an
E-R schema to Tables.
Relational Model: Structure of Relational
Database, The Relational Algebra, the tuple
relational calculus, The Domain Relational
Calculus, Views SQL- Background, Basic
UNIT 2 Structure, SET operations, Aggregate EXPERT LECTURE 10
functions, Null Values, Nested Sub queries,
Derived Relations, Views, Modification of
Database, Joined Relations, DDL, Other
SQL features.
Functional Dependency. Normalization: First
Normal Form, second normal form, Third
normal form, Boyce – Codd normal form,
Normalization Using Multi valued
Dependencies, Normalization Using Join
UNIT 3 ROLE PLAY 5
Dependencies, Domain- Key Normal Form
and Alternative Approaches to Database
Design.
Transaction- Transaction Concepts, State,
ACID properties, Implementations of
UNIT 4 Atomicity and durability, Concurrent GROUP DISCUSS 10
Executions, Serializability, Recoverability,
Transaction Definition in SQL.
Concurrency Control- Lock based
protocol, Time-stamp based protocol,
Validation based protocol, Multiple
UNIT 5 Granularity, Multi version Schemes, LECTURE 10
Deadlock Handing, Insert and Delete
operations, Concurrency in index structure
Query Optimization.
Part C
Indicative-ABCA/PBL/
Experiments/Field Bloom's
Modules Title Hours
work/ Level
Internships
UNIT 1 AND
PBL PBL BL4-Analyze 45
UNIT 2
UNIT 3 AND BL2-
EXPERIMENTS Experiments 20
UNIT 4 Understand
UNIT 5 CASE STUDY PBL BL5-Evaluate 20
Part D(Marks Distribution)
Theory
Total Minimum Passing External Min. External Internal Min. Internal
Marks Marks Evaluation Evaluation Evaluation Evaluation
100 40 60 18 40
Practical
Total Minimum Passing External Min. External Internal Min. Internal
Marks Marks Evaluation Evaluation Evaluation Evaluation
100 50 60 30 40
Part E
Silberschatz, A., Korth, H. F., & Sudarshan, S. (2001, July 1). Database Systems Concepts
Books
with Oracle CD. McGraw-Hill Science, Engineering & Mathematics.
Articles
Elmasri, R., & Navathe, S. (2011, January 1). Fundamentals of Database Systems. Addison
References Books
Wesley Longman.
MOOC Courses
Videos
Part F
Project 1 No project available
Project 2 No project available
Project 3 No project available
Project 4 No project available
Project 5 No project available
Course Articulation Matrix
COs PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PO11 PO12 PSO1 PSO2 PSO3
CO1 1 - - 2 - - - - 2 - - 1 - 1
CO2 3 3 1 2 2 - - - - 3 - - 2 - 3
CO3 2 2 1 - 2 - - - - - - - 3 2 3
CO4 2 2 - 1 1 - - - - - - - 3 3 3
CO5 1 2 - 1 1 - - - - - - - 3 3 3
CO6 - - - - - - - - - - - - - - -