4th SEM: RDBMS - SYLLABUS

 

SEMESTER IV

CORE PAPER-4

RELATIONAL DATABASE MANAGEMENT SYSTEMS

UNIT- I : DATABASE ARCHITECTURE AND ER DIAGRAM

Database system applications - Purpose of database systems - View of data- Database languages - Database architecture - Database users and administrators - History of database systems-Entity relationship modeling: entity types, entity set, attribute and key, relationships, relation types, roles and structural constraints, weak entities, enhanced E-R and object modeling, sub classes; super classes, inheritance, specialization and generalization

UNIT- II: RELATIONAL DATA MODEL

Relational model concepts, Relational constraints, Relational Languages : Relational Algebra, The Tuple Relational Calculus - The Domain Relational Calculus - SQL: Basic Structure-Set Operations- Aggregate Functions-Null Value-Nested Sub Queries-Views Complex Queries Modification Of Database-Joined Relations-DDL-Embedded SQL-Dynamic SQL-Other SQL Functions- -Integrity and Security.

 

 

UNIT - III: DATA NORMALIZATION

Pitfalls in relational database design – Decomposition – Functional dependencies – Normalization – First normal form – Second normal form – Third normal form – Boyce-codd normal form – Fourth normal form – Fifth normal form.

UNIT- IV: STORAGE AND FILE ORGANIZATION

Disks - RAID -Tertiary storage - Storage Access -File Organization – organization of files - Data Dictionary storage

UNIT- V: QUERY PROCESSING AND TRANSACTION MANAGEMENT

Query Processing - Transaction Concept - Concurrency Control - Locks based protocol Deadlock Handling -Recovery Systems.

TEXT BOOK

1. Abraham Silberschatz, Henry Korth, S.Sudarshan, Database Systems Concepts, Sixth Edition, McGraw Hill, 2010. 2. Raghu Ramakrishnan and Johannes Gehrke, Database management systems, Third Edition,2002

REFERENCES

1. Bipin Desai, An Introduction to database systems, Galgotia Publications, 2010. 2. RamezElamassri, Shankant B-Navathe, Fundamentals of Database Systems, Pearson, 7th Edition, 2015

E - REFERENCES

1. NPTEL, Introduction to database design, Dr P Sreenivasa Kumar Professor CS&E, Department, IIT, Madras

2. NPTEL, Indexing and Searching Techniques in Databases Dr. Arnab Bhattacharya, IIT Kanpur

 

   SYLLABUS IN PDF