MMC301

DATABASE MANAGEMENT SYSTEMS

OBJECTIVE: To introduce the concepts of database systems and to study in detail about relational databases.

1. INTRODUCTION [10]
Introduction to Database concepts — Definition of Schema and Subschema — DDL, DML, DCL — Data abstraction — Overall system structure.

2. DATA MODELS [10]
Network Data Model Hierarchical Data Model Relational Model — Entities and Relationships — ER Diagram Mapping constraints — Key constraints — Generalization Specialization and Aggregation — Reducing ER Diagram Tables.

3. RELATIONAL ALGEBRA AND CALCULUS [10]
Formal Query Languages — Relational Algebra and Relational Calculus — Commercial Query Languages — SQL, QBE.

4. DATABASE DESIGN [10]
Pitfalls in Relational database Design-Normalization using Functional dependencies — Boyce Codd Normal Form — Fourth Normal Form — Normalization using Join Dependencies — Domain Key Normal Form — Query Processing — Cost of Query Processing.

5. SECURITY AND TEGRITY IN DATABASE [10]
Database Administration — Performance issues — Concurrency Control — Security and Integrity — Distributed databases — Object Oriented Databases — Deductive Databases.

TEXT BOOK:
1. Henry F. Korth, Abraham Silberschatz, “Database System Concepts”, 1986, McGraw Hill.

REFERENCES:
1. Elmasri, Navathe, “Fundamentals of Database Systems”, 1994, Addison Wesley.
2. CJ.Date, “An introduction to Database Systems”, 1981, Addison Wesley.