2019

Course Description

Text Book

Fundamentals of Database Systems, 6th Edition, by Elmasri/Navathe, published by Addison-Wesley, 2010.
[download][Book]

WeekDateCovered TopicsComments
110/10Chapter 1: Course organization
217/10 and 24/10Chapter 1& 2 : Introduction to database systems- Databases and Database Users- database system concepts and architecture

331/10Chapter 7 : Data Modeling Using the Entity-Relationship Model
414/11 and 21/11Chapter 8 : Enhanced Entity-RelationshipFirst Exam 14/11/2016
528/11 and 14/12Chapter 3 : The relational data model.

Project – Phase 1 due on 9/11
621/12 and 23/12Chapter 9 : Conceptual to Relational Mapping

Second Exam on 2/12
728/12 and 30/12Chapter 15 : Functional dependencies, and normalization.Project – Phase 2 due on 28/12
8-/- and -/-Mid-term ExamMid-term: Chapter 1,2,3,7,8,9,13
9Chapter 6 : Relational algebra and Relational calculus
107/3Chapter 4&5 : The SQL database language 1.
1114/3Chapter 4&5 : The SQL database language 2.
1221/3Chapter 13 : Database programming techniques.Lab Exam on 16/3 Project
Phase 3 due on
1328/3 and 4/4Chapter 17 : Disk Storage, Basic File Structures and Hashing Chapter 18 : Indexing Structures for FilesThird Exam on 30/3
1411/4 and 18/4Chapter 18 : Indexing Structures for Files
15Project presentationProject – Phase 4 (final) due on
Presentation Evaluation
Presentation Schedule
16TBA