Lecture Slides:
- Information Systems (ppt) (pdf)
- Introduction (ppt) (pdf)
- Architecture (ppt) (pdf)
- Relational Data Model (ppt) (pdf)
- Relational Algebra (ppt) (pdf)
- SQL (ppt) (pdf)
- Relational Calculus (ppt) (pdf)
- Conceptual Database Design (ppt) (pdf)
- ER (ppt) (pdf)
- EER (ppt) (pdf)
- Mapping ER to Relational (ppt) (pdf)
- Mapping EER to Relational (ppt) (pdf)
- Informal Design Guide Lines (ppt) (pdf)
- Functional Dependency (ppt) (pdf)
- Normalization (ppt) (pdf)
- Practical Database Design (ppt) (pdf)
- Physical Database Design (ppt) (pdf)
- RAID (ppt) (pdf)
- Database Performance (ppt) (pdf)
- Query Processing and Optimization (ppt) (pdf)
- Transaction Processing and Concurrency Control (ppt) (pdf)
- Concurrency Control and Recovery (ppt) (pdf)
Assignments:
Quizzes:
- Quiz 1 (doc) (pdf)
- Quiz 2 (ppt) (pdf)
- Quix 3 (doc) (pdf)
- Quiz 4 (doc) (pdf)
- Quiz 5 (ppt) (pdf)
- Quiz 6 (doc) (pdf)
- Quiz 7 (doc) (pdf)
Exams: