4EC6.2-DATA BASE MANAGEMENT SYSTEM |
Units: I |
Introduction Need, purpose and goals of DBMS. DBMS Architecture, Concept of keys,
Generalisation and specialization, Introduction to Relational data model, ER Modeling, Relational
algebra.
|
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 calculus. |
Units: III |
SQL : DDL and DML. Constraints assertions, views, data base security. Application
Development using SQL : Host language interface, embedded SQL programming. GL's, Forms
management and report writers. Stored procedures and triggers.
|
Units: IV-INTERNAL OF RDBMS |
Physical data organization in sequential, indexed, random and
hashed files. Inverted and multilist structures.
|
Units: V |
Transaction processing, concurrency control, Transaction model properties and state
serialisability. Lock base protocols, two phase locking, Log based recovery Management.
|
|