Database Management Systems (Theory)

Paper Code: 
24CBDA213
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

24CBDA213

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, Database Design, Data Storage and Querying, Database Architecture, Data Mining and Information Retrieval, Specialty Databases, Database Users and 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: 

Suggested Text Books 

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

 

REFERENCES: 

SUGGESTED REFERENCE BOOKS

  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: 
2024-25
  • Printer-friendly version