7EE1 DATA BASE MANGEMENT SYSTEM

Unit-1 Introduction, need, purpose and goals of DBMS. DBMS Architecture, Concept of keys, Generalization and specialization, introduction to relational data model, ER modeling, concept of ER diagram.
Unit-2 Database Design: Conceptual Data Base design. Theory of normalization, Primitive and composite data types, concept of physical and logical databases, data abstraction and data independence, relational algebra and relational calculus.
Unit-3 SQL, DDL and DML. Constraints assertions, views database security. Application Development using SQL: Host Language interface, embedded SQL programming. GL’s, Forms management and report writers. Stored procedures and triggers. Dynamic SQL, JDBC.
Unit-4 Internal of RDBMS: Physical data organization in sequential, indexed, random and hashed files. Inverted and multilist structures.
Unit-5 (i) Transaction Management: Transaction concept, transaction state, serializability, conflict serializabiltiy, view serializability. (ii) Concurrency Control: Lock based protocol. (iii) Deadlock Handling: Prevention detection, recovery. (iv) Recovery System: Log based recovery.

Reference/Suggested Books
1. Silverschatz Korth and Sudarshan – Database System Concepts, 5th ed., Tata Mc-Graw Hill.
2. Raghu Rama Krishnan – Database Management Systems, 2nd ed., Tata Mc-Graw Hill.
3. Elmasari – Fundamentals of Data Base Systems, Pearson Education.
4. Gordon C. Everest – Database Management Objectives, System Functions