Professor Harry Wechsler
Department of Computer Science
George Mason University
Fairfax, VA 22030
e-mail: wechsler@cs.gmu.edu
www: http://cs.gmu.edu/~wechsler/
(703)993-1533(office)
(703)993-1530(sec)
(703)993-1710(fax)

GEORGE MASON UNIVERSITY
FALL 2005
CS 450 --- Database Concepts

Class Information
001    70064    M 4:30pm - 7:10pm   IN 134

Prerequisites
Grade of C or better in CS 310 and CS 330.

Each student enrolled in this class certifies
that he/she has the prerequisites listed above.

Office Hours
M 3:15pm - 4:00pm (Sci. Tech. II - Rm. 461)

You are responsible to read my emails sent to your GMU address.

Teaching Assistant
Ms. Younhee Kim – ykim9@cs.gmu.edu – < Please send your section number #1 when
contacting the TA > Tuesday 12 – 2 PM and Thursday 4 – 6 PM in ST – 2 room 422A

Textbook
1. Fundamentals of Database System, by Elmasri and Navathe,4th ed., Addison Wesley, 2004.

Text Book Slides

Chapter   1 Chapter   2 Chapter   3 Chapter 4a Chapter 4b
Chapter   5 Chapter   6 Chapter   7 Chapter   8 Chapter   9
Chapter 10 Chapter 11 Chapter 12 Chapter 13 Chapter 14
Chapter 15 Chapter 16 Chapter 17 Chapter 18 Chapter 19
Chapter 20 Chapter 21 Chapter 22 Chapter 23 Chapter 24

ORACLE Programming --- A Primer, by Rajshekhar Sunderraman, Addison Wesley, 2004.

ORACLE Programming

1. Oracle PL/SQL Programming complete manual HERE

2. Oracle SQL/LDR complete manual HERE

3. Other ORACLE manuals can be found at http://otn.oracle.com/ (required registration and it is free)

4. Oracle Technology Network:
http://www.oracle.com/technology/index.html

5. Official ORACLE web pages are available on IT&E web site at:
http://ite.gmu.edu/machines/oracle.html

6. How to Use ORACLE:
http://ise.gmu.edu/~ami/teaching/infs614/current/oracle.html

ORACLE – GMU -- INFORMATION
In order to get an Oracle account you need to activate your ITE account:
http://ite.gmu.edu/labs/reference/faq_oracle.htm

2. Contact Oracle DBA (Data Base Administrator): Oracle DBA

Course Description

Introductory course -- covers from basics to intermediate knowledge for the design,implementation
and use of (mostly relational) database systems. The main topics include the Entity-Relationship
(ER) and Entity-Enhanced Relationship (EER) models for database design, Relational Algebra (RA),
Structured Query Language (SQL), functional dependencies and normalization, and an introduction to
object-oriented (OO) and object-relational (OR) databases, data warehousing, and data mining, and
customer relationship management (CRM). Students will practice to design, develop, and implement a
relational ORACLE database through a comprehensive project and use the database for queries,
transaction processing, report generation, and a small CRM team project.

Homework
No late submissions accepted. No excuses.

Homeworks deal with the:
GEORGETOWN Apartment Database System
HMW1 due September 26 (EE/EER)
HMWA.1 due October 11 (relational algebra) à Solve 6.16, 6.18 and 6.22 from textbook
HMW2 due October 24 (SQL/DDL)
HMW3 and HMW4 due November 7 (SQL/PLSQL)
HMWA.2 due November 21 (normalization)
HMW5(Team CRM Project) due December 5

Team composition (4 – 5 students) and management for the CRM Project is the responsibility of the students.
For Customer Relation Management (CRM) please check at:
http://crm.ittoolbox.com/browse.asp?c=CRMPeerPublishing&r=http%3A//www.ittoolbox.com/peer/AP_website.htm

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.

Grading
Homeworks 1 – 4 & A.1 & A.2 = 5% each (for a 30% total)
Midterm = 20% = closed book and closed notes = bring blue book for exam
FINAL = 35% = closed book and closed notes = bring blue book for exam
Team CRM Project = 15%

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

August 29	Chaps. 1 & 2 :Database System Concepts and Architecture
September 5	Labor Day
September 12 & 19	Chaps. 3 & 4: ER (Entity Relationship) Model; The inheritance concept and the Enhanced ER (EER) Model
September 26	Chaps. 5 and 7: Relational Model and Schemas; Relational Database Constraints; Mapping ER/EER to Relations Chap. 6 : Relational Algebra
October 3	Chap. 8 : SQL
Make a note: class meets on TU rather than on Mo Tuesday October 11	Ch. 8: SQL REVIEW for Midterm.
October 17	Midterm (covers 8/29 – 9/26) lectures)
October 24 & 31	Chaps. 9 & Oracle 9i Primer: SQL, Embedded SQL and PL/SQL. Ch. 24.1 Active Database Concepts and Triggers. Chaps. 12 & 16: Data Base Design.
November 7	Ch. 10: Functional Dependencies and Normalization.
November 14	Customer Relationship Management (CRM) Chaps. 20 – 22: Objects and Object-Relational Databases. Ch. 23: Database Security and Authorization.
November 21-28	Chaps. 27 – 28: Data Mining and Data Warehousing. REVIEW for FINAL
December 5	Team CRM Projects - Demo
December 12	FINAL (covers EVERYTHING)