Fundementals of Database Systems
Course Description Objectives Attendance Policy Grading Policy
Teaching Methods Required Textbook Course Contents Down Load
|
3 Hrs. Lectures |
Credit Hours: |
|
CS 201, CS101 |
Pre-requisite: |
|
3 |
Course Level: |
Course Description (Top)
The course gives an introduction to database analysis, design, and implementation.
Course Objectives (Top)
-
To understand principles of database approach and terminology
-
To understand principles of database analysis, design, and implementation.
Attendance Policy (Top)
All students must have a minimum of 75% attendance, failing which may result in debarring from the course.
Grading Policy (Top)
Teaching Methods (Top)
Induction and Deduction Methods
Required Textbook (Top)
-
Fundamentals of Database Systems, Fourth Edition (or latest), Ramez Elmasri, Shamkant Navathe.
-
An Introduction to Database Systems; Seventh Edition (or latest), C. J. Date.
-
Database System Concepts, Third Edition (or latest), A. Silberschatz, H. Korth.
-
Other handouts the instructor find out it is necessary.
Course Contents (Top)
|
Week
|
Subject |
|
1 |
Basic concepts and terminology
|
|
2 |
|
3 |
characteristics of the database approach, the three level-schema architecture and data independence |
|
4 |
|
5 |
The Entity Relationship Model (notations and concepts) (ER) |
|
6 |
|
7 |
1st Mid-Term |
|
8 |
Enhanced Entity Relationship Model (EER) |
|
9 |
|
10 |
ER-and-EER-to-Relational Mapping |
|
11 |
|
12 |
2nd Mid-Term Exam |
|
13 |
Introduction to SQL standard |
|
14 |
|
15 |
Introduction to UML Class Diagrams |
|
16 |
|
17 |
Final Exams
|
Download (Top)
Fudementals of database (CS203).doc
CS203 Description and Lectures Delivery.doc
Attendance CS203.xls
Grades CS203.xls
Final Exam CS 203.doc
chap01.ppt chap02.ppt chap03.ppt chap04.ppt chap05.ppt
chap06.ppt chap07.ppt chap08.ppt chap09.ppt chap10.ppt
chap11.ppt chap12.ppt chap14-web.ppt chap15-web.ppt
chap13-abbrev.ppt chap14-abbrev.ppt chap15-abbrev.ppt