Dr Ali Obaidi   

Department of Computer Science

George Mason University
Fairfax, VA 22030
 

e-mail : aobaidi@cs.gmu.edu

www: http://cs.gmu.edu/~aobaidi/public_html(under construction)
(703)993-1530 (office)
(703)993-1710 (fax)
 

Spring '2002

CS 450 Database and Object-Oriented Concepts

updates 5/5/02: 

DEMO SCENARIO (download to see how the demo will be conducted)

Added clarification for section 6b (Project) PLEASE READ

 

Class Information

001   0720PM 1000PM ST1 122

Office Hours

 By appointment (email me)

Teaching Assistant

Patkar, Girija (gpatkar@gmu.edu)
Office hours  Thursday 7-30 to 8-30 pm and
Friday 12 to 1-00 pm.
The location is Room 12(which is called SUN lab), SITE 2.

Textbook

1. Fundamentals of Database System, Elmasri and Navathe, 3rd ed., Addison Wesley, 2000.

2. Database System Concepts, Fourth Edition,  Abraham Silberschatz,  Henry F. Korth and  S. Sudarshan

3.ORACLE 8 Programming--- A Primer by Sunderraman, Addison Wesley, 1999.

4. Oracle PL/SQL Programming  Click HERE (size 4MB.. allow time to download)
 

Course Description

Introductory course -- covers from basic to intermediate knowledge for the design, implementation
and use of database systems. The main topics include the Entity-Relationship (ER) and
Entity-Enhanced Relationship (EER) models and database design, Relational Algebra (RA),
Structured Query Language (SQL), functional dependencies and normalization for a relational database,
and a brief introduction to object-oriented and object-relational databases, data warehousing and data mining.
Students practice designing, developing and implementing a relational ORACLE database and use
the database for transaction processing, report generation, and queries. 
 
 

Class Notes

1. Class notes are provided by slides. check schedule below.

 

On-line documents

To get an ORACLE account contact : oracle@ite.gmu.edu

Official ORACLE web pages are available on IT&E web site at:

http://ite.gmu.edu/machines/oracle.html

http://ite.gmu.edu/new/faqs/oracleAccess.html
 

Grading

Homework - 30%. (no late submission. submit your homework at the beginning of the class).

Exam 1  20% 

Exam 2  25%

FINAL Project - 25%
 

Tentative Schedule
Please Observe copyright restrictions on slides. Concerns, please see me.
 

January 22	Chs. 1 and 2 : Introduction to Databases      (Slides Ch1)  (Slides Ch2)
January 29	Continue on Introduction; Ch. 3 : ER - Entity - Relationship Model  (Slides)
February 5	Continue on Ch 3.
February 12	Ch. 4 : Enhanced Entity – Relationship (EER) and Object Modeling  (Slides) ;  Ch. 5,6 : storage, indexing and primary file organization (self study)
February 19	Discussion  and Problem solving session
February 26	Exam 1
March 5	Ch. 7 : Relational Algebra (slides)
March 19	Continue on Ch 7 + Ch. 8 : SQL (slides) (Data-Model) (DDL)
March 26	Ch. 8 : SQL  Review on SQLPLUS, PLSQL and SQL Loader
April 2	Ch. 10 : Embedded SQL and ORACLE Programming --  Discussion and Prob. solving for EXAM 2; Project
April 9	Exam 2
April 16	Ch. 14 : Functional Dependencies and Normalization
April 23	Ch. 11/12 : Object Database Standards, Languages and Design (slides); Examples (1) (2)
April 30	continue Ch. 11/12 + Distributed Databases and Client-server architecture.
May 7	Project Demonstration (Groups and Demo Time)
May 8	Project Demonstration

 

Homework 1    10 Marks. (covers ch 1-4) due Feb 19

solve problems 1.9, 2.11, 3.21, 4.20 

Homework 2    10 Marks. (covers ch 7-10) due April 2

solve problems 7.19, 7.23, 7.27, 8.10, 8.11

Homework 3   10 Marks (12-14,24) due with the project

solve problems 14.26, 14.32, 12.17 

Project  25 Marks  Due May 7/8/9 depending on demo time.

Classroom Conduct
You are expected to be punctual, alert, and prepared for the class. Be considerate of other students, which includes being quiet for the duration of the class period, except when you have something to contribute to the class.

Please ask questions in class. If you are confused, more than likely several classmates are, too. If you need extra help, please schedule an appointment in advance, so the I can schedule my time efficiently.

Ethics/Honor Code

please read Academic Integrity statement