DATABASE MANAGEMENT SYSTEMS

Paper Code: 
CBDA 213
Credits: 
3
Periods/week: 
3
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 (COs).

Course Outcome (at course level)

 

Learning and teaching strategies

Assessment Strategies

 
 

On completion of this course, the students will

CO62.Apply the concepts of database into real-world scenario.

CO63.Develop the logical design of the database using data modeling concepts and deduce into relational schema.

CO64. Learn and apply Structured Query Language (SQL) for database definition and database manipulation

CO65.Create database for any application using normalization principles.

CO66.Analyse and compare transaction processing and concurrency control techniques

 

Approach in teaching:

Interactive Lectures, Tutorials, 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: 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 and recovery management:

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: 
  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:

  • Introduction to Database Systems and Design, IIT Madras: https://nptel.ac.in/courses/106106095

Journals:  

 

 

 

Academic Year: 
2023-24
  • Printer-friendly version