DATABASE MANAGEMENT SYSTEM

(Effective from the Academic Year 2022 - 2023)

V SEMESTER
Course Code 21CS5_ CIA Marks 50
Number of Contact Hours/Week (L: T: P: S) 3:0:0:0 SEE Marks 50
Total Hours of Pedagogy 40L Exam Hours 03
CREDITS – 3
COURSE PREREQUISITES:
● Knowledge of Data Structures
COURSE OBJECTIVES:
● Provide a strong foundation in database concepts, technology, and practice.
● Practice SQL programming through a variety of database problems.
● Demonstrate the use of concurrency and transactions in database.
● Design and build database applications for real world problems.
TEACHING - LEARNING STRATEGY:
Following are some sample strategies that can be incorporate for the Course Delivery
● Chalk and Talk Method/Blended Mode Method
● Power Point Presentation
● Virtual Lab
● Expert Talk/Webinar/Seminar
● Peer-to-Peer Activities
● Problem Based Learning
● MOOC/NPTEL Courses
● Any other innovative initiatives with respect to the Course contents
COURSE CONTENTS
MODULE - I
8 Hours
Introduction to Databases: Overview, Characteristics of database approach, Actors on the Scene, Workers
behind the Scene, Advantages of using the DBMS approach, History of database applications (Self Study).

Database System Concepts and Architecture: Data Models, Schemas, and Instances. Three schema
architecture and data independence, database languages, and interfaces, The Database System environment.

Basic SQL: SQL data definition and data types, specifying constraints in SQL, retrieval queries in SQL,
INSERT, DELETE, and UPDATE statements in SQL.

Textbook 1::Chapter 1(Sections 1.1 to 1.7), Chapter 2(Sections 2.1 to 2.4), Chapter 6(Sections 6.1 to 6.4)
MODULE - II
Data Modeling Using the Entity-Relationship (ER) Model: Entity types, Entity sets, attributes, roles, and 8 Hours
structural constraints, Weak entity types, ER diagrams, Relationship Types of Degree Higher than Two,
Examples.

Relational Database Design by ER-to-Relational Mapping: Relational Database Design using ER-to-
Relational mapping.

The Relational Data Model and Relational Database Constraints: Relational Model Concepts,
Relational Model Constraints and relational database schemas, Update operations, transactions, and dealing
with constraint violations.

Textbook 1: Chapter 3 (Sections 3.1 to 3.10), Chapter 9 (Sections 9.1), Chapter 5 (Sections 5.1 to 5.3)
MODULE - III
The Relational Algebra and Relational Calculus: Unary Relational Operations: SELECT and PROJECT, 8 Hours
Relational Algebra Operations from Set Theory, Binary Relational Operations: JOIN and DIVISION,
Additional relational operations (aggregate, grouping, etc.), Examples of Queries in relational algebra.

SQL: Advances Queries: More complex SQL retrieval queries, Specifying constraints as assertions and
action triggers, Views in SQL, Schema change statements in SQL.

Textbook 1: Chapter 8 (Sections 8.1 to 8.5), Chapter 7 (Sections 7.1 to 7.4)

MODULE - IV
Basics of Functional Dependencies and Normalization for Relational Databases: Informal Design 8 Hours
Guidelines for Relation Schemas, Functional Dependencies, Normal Forms based on Primary Keys,
General Definitions of Second and Third Normal Forms, Boyce-Codd Normal Form.

Relational Database Design Algorithms and Further Dependencies: Inference Rules, Equivalence, and
Minimal Cover, Properties of Relational Decompositions, Algorithms for Relational Database Schema
Design.

Textbook 1: Chapter 14 (Sections 14.1 to 14.5), Chapter 15 (Sections 15.1 to 15.3)

MODULE - V
Introduction to Transaction Processing Concepts and Theory: Introduction to Transaction Processing, 8 Hours
Transaction and System concepts, Desirable properties of Transactions, Characterizing schedules based on
recoverability, Characterizing schedules based on Serializability, Transaction support in SQL.

Concurrency Control Techniques: Two-phase locking techniques for Concurrency control, Concurrency
control based on Timestamp ordering.

Textbook 1: Chapter 20 (Sections 20.1 to 20.6), Chapter 21 (Sections 21.1 to 21.2)

COURSE OUTCOMES
Upon completion of this course, the students will be able to:
Bloom’s
CO
No.
Course Outcome Description Taxonomy
Level
Discuss the fundamental concepts of database technology and illustrate the fundamental
CO1 CL3
concepts of Structured Query Language (SQL) for database manipulation.
Make use of Entity Relationship (ER) model to illustrate conceptual database design and
CO2 CL3
describe the basic principles of relational model
Examine the concepts of relational algebra and advanced Structured Query Language in
CO3 CL3
database application development
Apply the functional dependency to measure the appropriateness of attribute groupings into
CO4 CL3
relation schemas and discuss the process of normalization with its algorithms.
Identify the basic concepts and theory needed for transaction processing, concurrency control in
CO5 CL3
database applications
CO-PO-PSO MAPPING
Programme
CO Programme Outcomes (PO) Specific
No. Outcome (PSO)
1 2 3 4 5 6 7 8 9 10 11 12 1 2
CO1 3 2 1 2
CO2 3 2 1 3 2
CO3 3 2 1 2
CO4 3 2 1 1 2
CO5 3 3 2 2 2 3 2
3: Substantial (High) 2: Moderate (Medium) 1: Poor (Low)
 ASSESSMENT STRATEGY
Assessment will be both CIA and SEE. Students learning will be assessed using Direct and Indirect methods:
Sl. No. Assessment Description Weightage (%) Max. Marks
1 Continuous Internal Assessment (CIA) 100 % 50
Continuous Internal Evaluation (CIE) 60 % 30
Assignments 40 % 20
2 Semester End Examination (SEE) 100 % 50
ASSESSMENT DETAILS
Continuous Internal Assessment (CIA) (50%) Semester End Exam (SEE) (50%)
Assignment/
Continuous Internal Evaluation (CIE) (60%) Activities (40%)
I II III
Syllabus Coverage Syllabus Coverage Syllabus Coverage
40% 30% 30% 100% 100%
MI MI MI
MII MII MII MII
MIII MIII MIII
MIV MIV MIV
MV MV MV
Note: For Examinations (both CIE and SEE), the question papers shall contain the questions mapped to the
appropriate Bloom’s Level. Any COs mapped with higher cognitive Bloom’s Level may also be assessed through the
assignments.
ASSIGNMENT TYPES WITH WEIGHTAGES
Sl. No. Assignment Description Max. Weightage (%) Max. Marks
1 Written Assignments 25 % 05
2 Quiz 10 % 02
3 Case Studies 25 % 05
4 Seminar/Presentation 15 % 03
5 Peer - to - Peer Learning 10 % 02
6 Activity Based Learning 50 % 10
7 Project Based Learning 50 % 10
8 Field Work + Report 50 % 10
9 Industry Visit + Report 50 % 10
NPTEL/MOOC Courses – Registration and Assignment
50 % 10
10 Submissions
NPTEL Certification 75 % 15
11 Any other Innovative Assignments (CL4 and above) 50 % 10
Note: The assignments mentioned above may be provided appropriately to the students belonging to different bands
SEE QUESTION PAPER PATTERN:
● The question paper will have TEN full questions from FIVE Modules
● There will be 2 full questions from each module. Every question will carry a maximum of 20 marks.
● Each full question may have a maximum of four sub-questions covering all the topics under a module.
● The students will have to answer FIVE full questions, selecting one full question from each module.
TEXT BOOKS:
1. Fundamentals of Database Systems, Ramez Elmasri and Shamkant B. Navathe, 7th Edition, 2017, Pearson.
2. Database management systems, Ramakrishnan, and Gehrke, 3rd Edition, 2014, McGraw Hill
REFERENCE BOOKS:
1. Silberschatz Korth and Sudharshan, Database System Concepts, 6th Edition, Mc-GrawHill, 2013.
2. Coronel, Morris, and Rob, Database Principles Fundamentals of Design, Implementation and Management,
Cengage Learning 2012.
REFERENCE WEB LINKS AND VIDEO LECTURES (E - RESOURCES):
1. https://www.youtube.com/watch?v=6Iu45VZGQDk&list=PLBlnK6fEyqRi_CUQ-FXxgzKQ1dwr_ZJWZ
2. https://www.youtube.com/watch?v=IoL9Ve2SRwQ&list=PLIwC9bZ0rmjSkm1VRJROX4vP2YMIf4Ebh
3. https://www.youtube.com/watch?v=OMwgGL3lHlI&list=PLBlnK6fEyqRiyryTrbKHX1Sh9luYI0dhX
4. https://onlinecourses.nptel.ac.in/noc23_cs41/preview
5. http://vlabs.iitkgp.ernet.in/se/4/