Cs450

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 of a relational database,
and a brief introduction to object-oriented and object-relational databases, data warehousing, and data mining.
Students will practice to design, develop, and implement a relational ORACLE database through a comprehensive
project and use the database for queries, transaction processing, and report generation.

Home Work

ONLY students registered on Net section can submit their homework by email.

All other students please note:

· Homework need to be submitted at the start of the lecture Due Date (first 15 min).

· Do not submit your homework to the TA.

· Homework is accepted only in hard copy.

No late submission accepted. No excuses.

HMW1 due September 23

HMW2 due September 30

HMW3 due October 28

HMW4 due November 4

HMW5 due November 18

Term TEAM Project – due (week of) December 6

Team composition is up to the students. I expect 5 teams of 5 students and 1 team of 6 students.

GMU Honor Code

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 need extra help, please schedule an
appointment in advance, so I can schedule my time efficiently.

Academic Policies and Honor Code http://cs.gmu.edu/students/hnr_cds.html procedures will be
strictly adhered. Students are required to be familiar with the honor code. Violations of the honor code will
be reported. Homework assignments must be based on the student’s own effort.

Grading

Home Work = 25%

Exam #1 = 25% = closed book and closed notes = bring blue book for exam

Exam #2 = 25%

Project = 25%

Letter Grade	Numeric Equivalent
A+	95+
A	92+
A-	89+
B+	86+
B	80+
B-	77+
C+	73+
C	66+
C-	62+
D	55+

Tentative Schedule

September 2	Chs. 1 & 2 :Database System Concepts and Architecture
September 9 & 16	Chs. 3 & 4 & 7: ER (Entity Relationship) Model, Enhanced ER Model, and ER Mapping
September 23 & 30	Chs. 5 & 6 : Relational Model; REVIEW (discussion and problem solving) for EXAM #1
October 7	EXAM #1 (covers 9/2 – 9/30 lectures except Ch. 6)
October 14 & 21&28	Ch. 8 :SQL; Ch. 9 & Oracle 9i Primer: Embedded SQL and PL/SQL; Ch. 24.1 Active Database Concepts and Triggers. Discussion and Problem Solving.
November 4 & 11	Chs. 12 & 16: Data Base Design; Ch. 10 : Functional Dependencies and Normalization.
November 18	Chs. 20 – 22: Object and Object-Relational Databases; Ch. 23: Database Security and Authorization;
November 25	Thanksgiving Recess
December 2	Chs. 27 – 28: Data Mining and Data Warehousing ; REVIEW (discussion and problem solving) for EXAM #2
December 6	Project Groups Demos
December 9	EXAM #2 (covers 10/14 – 11/18 lectures)