DBMS Theory

Unit I DATABASE SYSTEMS 

  1. Basic Definitions 
  2. Database types and database applications
  3. File system Vs Database system

Unit II DATA MODELING 
ER Model – Relational Model – Mapping ER model to a relational schema – entity and
referential integrity – Database query languages: Overview of database languages;
Relational Algebra –SQL
Unit III RELATIONAL DATABASE DESIGN 
Guidelines for Relational Schema – functional dependency; normal forms; multi-valued
dependency; join dependency
Unit IV QUERY PROCESSING AND TRANSACTION PROCESSING
SQL queries into Relational Algebra – heuristic query optimization – Introduction to
Transaction Processing – Transaction and System concepts – Desirable properties of
Transactions – Concurrency Control : concepts and Two-Phase Locking
Unit V PHYSICAL DATABASE DESIGN 
Storage and file structure: indexed files; hashed files; signature files; b+-trees; files with
dense index; files with variable length records.

No votes yet.
Please wait...

FOR THE NERDS