7EE1-DATA BASE MANGEMENT SYSTEM |
Units: I |
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.
|
Units: II-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. |
Units: III |
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.
|
Units: IV-Internal of RDBMS: |
Physical data organization in sequential, indexed, random and hashed
files. Inverted and multilist structures.
|
Units: V |
(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.
|
|