Database Management Systems

Paper Code: 
25CBDA213
Credits: 
03
Periods/week: 
03
Max. Marks: 
100.00
Objective: 

This Course enables the students to

1.   Observe that how  the  real  world  data is stored, retrieved, and  communicate under the DBMS environment

2.   Design  a logical model  which  having  the  unique relation between the  Data.

3.   Learn  various advance concepts of transaction processing and  recovery.

 

Course Outcomes: 

Course

Learning outcome

(at course level)

Learning and teaching strategies

Assessment

Strategies

Course

Code

Course

Title

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

25CBDA213

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Database Management Systems (Theory)

CO73.   Identify  the role  of database and its     applications     in real-world scenario. CO74.Develop     the logical  design  of  the database using   data modeling      concepts and      deduce     into relational schema. CO75.             Apply Structured       Query Language   (SQL)  for database    definition and                database manipulation CO76.Create database    for     any application         using normalization principles. CO77.Analyse     and compare  transaction processing           and concurrency   control techniques

CO78. Contribute effectively in course- specific  interaction

Approach in teaching: Interactive Lectures, Demonstrations, Learning activities for the students: Self-learning assignments, Quizzes, Presentations, Discussions

 Assignment

  Classroom activity

 Multiple choice questions

 Semester End Examination

 

9.00
Unit I: 
Introduction to Database

Database   System  Applications,   Database   Systems  versus  File   Systems, Purpose  of Database  Systems, View  of  Data, Database Languages,  Relational Databases, DatabaseDesign, Data  Storage and  Querying, Database Architecture, Data  Mining and  Information Retrieval,  Specialty  Databases, Database Userand  Administrators,  History  of  Database Systems.

 

9.00
Unit II: 
Entity-Relationship Model:

Basic  concepts,  Constraints:  Participation  constraints  and Cardinality   ratio,   Removing  Redundant Attributes  in  Entity  Sets, Reduction  to  Relational Schemas, E-R diagram, Weak  Entity Sets.

 

9.00
Unit III: 
Introduction to SQL:

SQL Data  Definition,  Basic  Structure, Additional  Basic  Operations, Set    Operations,   Null   Values,    Aggregate   Functions,   Modification    of   the    Database. Intermediate SQL: Join  Expressions, Views,  Transactions, Integrity Constraints, SQL Data Types  and  Schemas, Authorization, Roles.

9.00
Unit IV: 
Relational-Database Design:

First  Normal  Form,  Pitfalls  in Relational-Database Design, Functional Dependencies, Decompositions, Third Normal  Forms, Boyce-Codd Normal  Form.

 

9.00
Unit V: 
Overview of transaction processing , recovery management and Concurrency control:

Transaction  Processing: Introduction  to  Transaction  Processing, Transaction  and   System concepts, Desirable properties of Transactions. Schedules:  Characterizing Schedules Based on Recoverability and  Serializability.

Concurrency control  techniques: Locking and  Timestamp ordering based.

Recovery management:  Types  of failures,  Recovery outline,  Caching  of Disk blocks,  Write ahead logging,  Steal/No  Steal   and   Force/No Force,   Checkpoints  in  the   System Log  and Fuzzy Check  pointing

 

ESSENTIAL READINGS: 

1.   Abraham Silberschatz, Henry  Korth,  S. Sudarshan, “Database Systems Concepts”, 7th  Edition,  McGraw Hill, 2021.

 

REFERENCES: 

SUGGESTED READINGS:

1.   R. Elmarsi and  S.B. Navathe, “Fundamentals of Database Systems”, Addison Wesley,  7th  Ed., 2016.

2.   A. K. Majumdar, P. Battacharya, “Database Management Systems’, TMH, 2017.

3.   Bipin Desai,  “An Introduction to Database Systems”, Galgotia  Publications, 2015.

e-RESOURCES:

1.   Mysql, Spoken Tutorial: https://spoken-tutorial.org/

2.   https://www.slideshare.net/MedHEDHLY/database-management-systems-27179628 Introduction to Database Systems and  Design, IIT Madras:https://nptel.ac.in/courses/106106095

JOURNALS:

1.   https://www.journals.elsevier.com/international-journal-of-information-management- data-insights

2.   https://dl.acm.org/journal/jdbm

 

Academic Year: 
2025-26
  • Printer-friendly version