Syllabus
Course Hand out (or) Lesson Plan
MID - I MARKS - THEORY
Academic Calendar ( Revised & New )
Unit - I
- Database System vs File System - Video
- video2 - Unit -1 - outline
- ppt for notes - click here
Objective Questions - Unit I
Unit - II
Assignment - Answer all questions from Mid I Descriptive Question Paper
Unit - III
Unit - IV
- Functional Dependencies
- Normalization - 1NF,2NF,3NF,BCNF, MVD & 4NF, Lossless Join decomposition, JD & 5NF, ID-Inclusion dependency.
Unit - V
- Transaction System - Desirable properties of transaction
- Testing of Serializability
- Serializability of schedules
- Conflict & View Serializable Schedule
- recoverability
- Log based recovery - external link
- Check Points
- ARIES algorithm - external link
- Deadlock handling - external link
