Database I

 [Database I] Syllabus

[Fall 2018/2019]

Instructor Information

Instructor

Email

Office Location & Hours

[Dr. Mouhib Alnoukari]

[[email protected]]

[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, 5th 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

 

Syrian Private University - Faculty of of Computer and Information Engineering @ 2021 by Syrian Monster - Web Service Provider | All Rights Reserved