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 2006
CS 450 --- Database Concepts
Class Information
001 70572 M 1:30pm - 4:15pm IN 136
Prerequisites
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 12:30 pm - 1:15 pm (Science & Tech. II - Rm. 461).
You are responsible to read my emails sent to
your GMU address.
Teaching Assistant
TBD
Textbooks
1. Fundamentals
of Database System, by Elmasri and Navathe, 5th ed.,
Addison Wesley, 2007.
Text Book Slides
see
first page of the book for Online Access for
Fundamentals of Database Systems, 5/e
2. 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. How to Use ORACLE:
http://ise.gmu.edu/~ami/teaching/infs614/current/oracle.html
ORACLE – GMU -- INFORMATION
Effective
immediately, the system used by students to create
their accounts on the IT&E unix
cluster (aka sun.ite, chrono.ite)
has
been eliminated. Accounts will be created automatically based on student
enrollment and students will use their gmu.edu email ID and passwords to
login to zeus, cpe02, and
other student Unix/Solaris/Linux systems.
Oracle passwords are assigned through a web interface. Further details
are in the FAQ section on http://labs.ite.gmu.edu
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), SQL programming techniques, functional dependencies and normalization,
and security. Advanced topics covered
include enhanced data models, data warehousing
and data mining, knowledge management, customer relationship management (CRM)
and recommendation systems.
The emerging database technologies and applications discussed include mobile
databases, multimedia databases,
geographic information systems, and genome data management. . Students will
practice to design, develop, and implement a
relational ORACLE database, and use the database for queries, transaction
processing, and report generation.
Homework
Late submissions are not accepted.
HMW1 due September 25 (EE/EER)
HMWA.1 due October 10 (EER, relational database model, and relational algebra) (Chaps.
4 – 6)
HMW2 due October 30 (SQL/DDL)
HMW3 (SQL) and HMW4 (SQL/PLSQL) due November 13
HMWA.2 due November 20 (normalization)
HMW5 (report [CRM] generation) due December 4
Customer Relation Management (CRM)
http://crm.ittoolbox.com/browse.asp?c=CRMPeerPublishing&r=http%3A//www.ittoolbox.com/peer/AP_website.htm
GMU
Honor Code
http://www.gmu.edu/departments/unilife/honorcode.html
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
Homework 1 – 4 & A.1 & A.2 = 5% each (for a 30% total)
Homework
5 = 10%
Class
Participation = 5%
Midterm = 25 % = closed book and closed notes =
bring blue book for exam
FINAL = 35 % = closed book and closed notes =
bring blue book for exam
|
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 28 |
Chaps. 1 & 2 :Databases,
Database System Concepts |
|
September 4 |
Labor Day |
|
September 11 & 18 |
Chaps. 3 & 4: ER
(Entity Relationship) |
|
September 25 – October 2 |
Chap. 5. Relational Model
and Chap. 7: Relational
Database Design Using ER- and EER- to Relational Mappings. |
|
NOTE class meets on Tuesday - October 10 – Instead of Monday, October 9 (Columbus Day) |
Chap 8: SQL |
|
October 16 |
Chap. 9: SQL programming – embedded SQL and PL/SQL
(see also Oracle 9i Primer) REVIEW for Midterm |
|
October 23 |
Midterm (covers 8/28 –10/2 lectures) |
|
October 30 – November 6 |
Chap. 10: Functional
Dependencies Chap. 16: Physical Database Tuning |
|
November 13 |
Chap. 20: Concepts for
Object Databases; Knowledge
Management |
|
November 20 - 27 |
Chaps. 28 – 29: Data
Mining and and Applications
|
|
December 4 |
REVIEW for
FINAL |
|
December 18 |
FINAL (covers EVERYTHING) |