alaidiText Book
Fundamentals of Database Systems, 6th Edition, by Elmasri/Navathe, published by Addison-Wesley, 2010.
[download][Book]
| Week | Date | Covered Topics | Comments |
|---|---|---|---|
| 1 | 10/10 | Chapter 1: Course organization | |
| 2 | 17/10 and 24/10 | Chapter 1& 2 : Introduction to database systems- Databases and Database Users- database system concepts and architecture | Chapter 1 chapter 2 |
| 3 | 31/10 | Chapter 7 : Data Modeling Using the Entity-Relationship Model | Chapter 7 |
| 4 | 14/11 and 21/11 | Chapter 8 : Enhanced Entity-Relationship | First Exam 14/11/2016 Chapter 8 |
| 5 | 28/11 and 14/12 | Chapter 3 : The relational data model. | Chapter 3 Project – Phase 1 due on 9/11 |
| 6 | 21/12 and 23/12 | Chapter 9 : Conceptual to Relational Mapping | Chapter 9 Second Exam on 2/12 |
| 7 | 28/12 and 30/12 | Chapter 15 : Functional dependencies, and normalization. | Project – Phase 2 due on 28/12 |
| 8 | -/- and -/- | Mid-term Exam | Mid-term: Chapter 1,2,3,7,8,9,13 |
| 9 | Chapter 6 : Relational algebra and Relational calculus | ||
| 10 | 7/3 | Chapter 4&5 : The SQL database language 1. | Chapter 4-5 |
| 11 | 14/3 | Chapter 4&5 : The SQL database language 2. | Company SQLSQL Joins TRIGGERS |
| 12 | 21/3 | Chapter 13 : Database programming techniques. | Lab Exam on 16/3 Project Phase 3 due on |
| 13 | 28/3 and 4/4 | Chapter 17 : Disk Storage, Basic File Structures and Hashing Chapter 18 : Indexing Structures for Files | Third Exam on 30/3 |
| 14 | 11/4 and 18/4 | Chapter 18 : Indexing Structures for Files | |
| 15 | Project presentation | Project – Phase 4 (final) due on Presentation Evaluation Presentation Schedule Project Report Example | |
| 16 | TBA |