Instructor Information

Instructor	Email	Office Location & Hours
[Dr. Mouhib Alnoukari]	[Mouhib.alnoukari@gmail.com]	[Location, Hours, Days]

General Information

Description

The main goal of the Database course is to introduce the database essentials to SPU students. Including their types, designs, and query languages. The student should be able to write SQL queries, and implement them using lab sessions, and relate it to Relational Algebra. He should also be able to understand and develop Entity Relationship Diagrams (ERD), and design a normalized relational data bases.

Expectations and Goals

1- Introduction to database

2- Introduction to Relational Model

3- SQL Language

4- Database Design and ER-Model

5- Relational Database Design

Language(s) of Instruction: Arabic/English Textbook(s) Language(s): English

Course Materials

- Data Base System Concepts, 5^th edition, by Silberschatz, Korth, Sudarshan

Course Schedule

	Week	Topic	Reading	Exercises
1	22/9- 26/9	Introduction to Databases	Silberschatz-Ch.1	SQL Env. and tools
2	29/9- 03/10	Introduction to Relational Model	Silberschatz-Ch.2	Relational model exercises
3	06/10- 10/10	Introduction to SQL	Silberschatz-Ch.3	SQL language – DDL
4	13/10- 17/10	Introduction to SQL	Silberschatz-Ch.3	SQL language – DML
5	20/10- 24/10	Introduction to SQL	Silberschatz-Ch.3	SQL language – DML
6	03/11- 07/11	Intermediate SQL	Silberschatz-Ch.4	SQL language – Join
7	10/11- 14/11	Intermediate SQL	Silberschatz-Ch.4	SQL language – Subquery
8	17/11- 21/11	Relational Algebra	Silberschatz-Ch.6	Relational algebra exercises
9	24/11- 28/11	Database Design and ER-Model	Silberschatz-Ch.7	ERD exercises
10	01/12- 05/12	Database Design and ER-Model	Silberschatz-Ch.7	ERD exercises
11	15/12- 19/12	Relational Database Design	Silberschatz-Ch.8	Normalization
12	22/12- 26/12	Relational Database Design	Silberschatz-Ch.8	Normalization
13	22/12- 26/12	Relational Database Design	Silberschatz-Ch.8	Normalization
14	29/12- 02/01	Relational Database Design	Silberschatz-Ch.8	Normalization
15

Testing Schedule

Test	Date	Subject	Reading	Type	language	% of final grade
Quizz 1	27/10-1/11	Introduction to databases & relational model - SQL	Chapters: 1,2,3	MCQ/written	Arabic/English	10
Quizz 2	8/12-13/11	SQL - ERD	Chapters: 3, 4, 6, 7	MCQ/written	Arabic/English	10
Final Exam	5/1-17/1	SQL – ERD – Relational Algebra - Normalization	Chapters: 3, 4, 6, 7,8	MCQ/written	Arabic/English	50