BX4004 Database Management Systems Syllabus:

BX4004 Database Management Systems Syllabus – Anna University PG Syllabus Regulation 2021

OBJECTIVES:

 To understand the fundamentals of data models and conceptualize and depict a database system using ER diagram.
 To make a study of SQL and relational database design.
 To know about data storage techniques and query processing.
 To impart knowledge in transaction processing, concurrency control techniques and recovery procedures.

UNIT I INTRODUCTION

File systems versus Database systems – Data Models – DBMS Architecture – Data Independence – Data Modeling using Entity – Relationship Model –E-R Modeling.

UNIT II RELATIONAL MODEL AND QUERY EVALUATION

Relational Model Concepts – Relational Algebra – SQL – Basic Queries – Complex SQL Queries – Views – Constraints

UNIT III DATABASE DESIGN & APPLICATION DEVELOPMENT

Functional Dependencies – Non-loss Decomposition – First, Second, Third Normal Forms, Dependency Preservation – Boyce/Codd Normal Form – Multi-valued Dependencies and Fourth Normal Form – Join Dependencies and Fifth Normal Form.

UNIT IV TRANSACTION PROCESSING

Quey Pocessing-Transaction Processing – Properties of Transactions – Serializability – Transaction support in SQL – Locking Techniques –Validation Techniques –– Recovery concepts – Shadow paging – Log Based Recovery.

UNIT V FILES AND INDEXING

File operations – Hashing Techniques – Indexing – Single level and Multi-level Indexes – B+ tree – Static Hashing

LIST OF EXPERIMENTS:

Data Definition Commands to create, describe, alter, rename, drop and truncate the tables
1. Data Manipulation Commands for inserting, deleting, updating and retrieving in Tables
2. Transaction Control Language Commands like Commit, Rollback and Save Point
3. Illustrate the statements to create index and drop index
4. Perform database querying using simple query, nested query, subquery and join operations
5. Create a PL/SQL block to implement implicit and explicit cursors
6. Create a PL/SQL block to implement procedures and functions
7. Create a PL/SQL block to execute triggers
8. Execute a procedure which handles exception using PL/SQL
9. Create a embedded PL/SQL block to connect with any host language like ‘C’

COURSE OUTCOMES:

Upon Completion of the course, the students will be able to
 Understand the basic concepts of the database and data models.
 Design a database using ER diagrams and map ER into Relations and normalize the relations
 Acquire the knowledge of query evaluation to monitor the performance of the DBMS.
 Develop a simple database applications using normalization.
 Acquire the knowledge about different special purpose databases and to critique how they differ from traditional database systems.

TOTAL : 75 PERIODS

REFERENCES:

1. Abraham Silberschatz, Henry F.Korth and S.Sundarshan “Database System Concepts”, Seventh Edition, McGraw Hill, 2017.
2. Ramez Elmasri and Shamkant Navathe, “Fundamentals of Database Systems”, Seventh Edition, Pearson Education Delhi, 2017
3. Raghu Ramakrishnan, ―Database Management Systems‖, Fourth Edition, McGraw Hill College Publications, 2015.
4. Lee Chao, “Database Development and Management”, Auerbach Publications, 1st edition, 2010
5. Carlos Coronel, Peter Rob, and Stephen Morris, “Database Principles Fundamentals of Design, Implementation, and Management –10th Edition”, Course Technology, Cengage Learning, 2013
6. C.J. Date, “An Introduction to Database Systems”, Eighth Edition, Pearson Education Delhi, 2003