التحديثات:

Database Design

Text Book

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

Download


Database Design Final Project Guideline

Project Report Example

Student Group

Handout

Syllabus

Week Date Covered Topics Comments
1 29/9 Chapter 1: Course organization  
2 12/10 and 19/10 Chapter 1& 2 : Introduction to database systems- Databases and Database Users- database system concepts and architecture Chapter1
Chapter2
3 26/10 Chapter 7 : Data Modeling Using the Entity-Relationship Model First Exam 5/11/2015
Chapter 7
4 2/11 and 9/11 Chapter 8 : Enhanced Entity-Relationship Project - Phase 1 due on 9/11
Chapter 8
5 7/12 and 14/12 “Chapter 3 : The relational data model.Chapter 3  
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.  
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
16   TBA