Knowledge in database managment

database managment

1. Introduction to Schema Refinement 2. Functional Dependencies 3. Normal Forms 4. Decompositions 5. Schema refinement in database design 6. Fourth Normal Form 7. Fifth normal form

database managment

1. Data on external storage & File organization and indexing 2. Index data structures 3. Comparison of file organizations 4. Comparison of file organizations 5. Indexes and performance tuning 6. Indexes and performance tuning 7. Intuition for tree indexes & ISAM 8. B+ tree

database managment

1. Transaction concept & State 2. Implementation of atomicity and durability 3. Serializability 4. Recoverability 5. Implementation of isolation 6. Lock based protocols 7. Lock based protocols 8. Timestamp based protocols 9. Validation based protocol 10. Recovery and Atomicity & Log based recovery