Database Systems Lab
Course Description Objectives Attendance Policy Grading Policy
Teaching Methods Required Textbook Course Contents Down Load
|
3 Hrs (1Hrs lecture + 2Hrs lab) |
Credit Hours: |
|
CS 203 |
Pre-requisite: |
|
4 |
Course Level: |
Course Description (Top)
The course gives the needed practice to manage a realistic database project that includes planning, requirement analysis, design, and implementation.
Course Objectives (Top)
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)
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 |
Choosing a Suitable Real Case Study
|
|
2 |
|
3 |
Collecting User Requirements and its documentation |
|
4 |
|
5 |
Developing an EER diagram of the Case Study |
|
6 |
|
7 |
1st Mid-Term |
|
8 |
The EER-to-Relational Mapping Producing the logical Design Model |
|
9 |
How to Use SQL Language and the language concepts and instructions |
|
10 |
|
11 |
|
12 |
2nd Mid-Term Exam |
|
13 |
The logical Design-to-SQL Mapping and implementation |
|
14 |
|
15 |
Testing the Produced Project Database |
|
16 |
|
17 |
Final Exams
|
Download (Top)
Database systems lab (CS212).doc
CS212 Description and Lectures Delivery.doc
Attendance CS212.xls Grades CS212.xls
Final Exam CS 212.doc
Sample of team Project.doc Students Achieved CS212 Projects.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