7EX1-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 erializabiltiy, view serializability. (ii) Concurrency Control: Lock
based protocol. (iii) Deadlock Handling: Prevention detection, recovery. (iv) Recovery
System: Log based recovery.
|
|