|
COMP 233 Database Systems Lab |
Course Title: |
|
3 Hours ( 1 hrs. Lecture + 2 hrs Lab) |
Credit Hours: |
|
COMP 124 Data Base Systems |
Pre-requisite: |
|
Level – 3 |
Course Level: |
|
Saturday, Monday 15:00 – 16:50 A.M.,
Tuesday 13:00 – 13:50A.M. |
Time: |
Course Objectives
- To put into practice what the student have learned in Database course.
- To learn how to manage a realistic database project.
- To learn how to document the project development phases
Attendance Policy
All students must have a minimum of 75% attendance, failing which may result in debarring from the course.
Grading Policy
Major Exam – I: 20%
Major Exam – II: 20%
Assignments & Quizzes: 10%
Final Exam: 50%
Teaching Methods
Using Power point slides and projector, using white and black boards to explain the topics with examples.
Required Textbook
· Elmasri and Navathe, Fundamentals of Database Systems, Fourth Edition (or latest), 2003
· SCOTT URMAN, Oracle 10G SQL programming, by ORACLE PRESS.
Course Contents:
|
TOPICS |
WEEK |
|
Introduction to Oracle |
1 |
|
SQl data types and literals |
2 |
|
Types of SQl commands(DDL, DCL, DML). |
3 |
|
SQl Operators and their precedence |
4 |
|
Tables, views and Indexes |
5 |
|
Queries and Sub queries |
6 |
|
.Queries and Sub queries |
7 |
|
First Theoretical Exam, First Practical Exam |
8 |
|
Functions |
9 |
|
Insert, Update and Delete operations. |
10 |
|
Joins, Unions, Intersection, Minus. |
11 |
|
Second Theoretical Exam, Second Practical Exam |
12 |
|
Cursors in SQl, Embedded SQL. |
13 |
|
Triggers, procedures |
14 |
|
Revision |
15 |