|
||||
|
Prerequisites: C or better in CS 310 and CS 330 |
||||
|
Required textbook: Database Management Systems, 3-rd ed. by Raghu Ramakrishnan & Johannes Gehrkem, McGraw-Hill. Recommended: |
||||
|
On-Line Course Resources: classweb.gmu.edu/brodsky/cs450 (You are required to read all the material there. The content may be updated frequently. So check the web site periodically, at least once every week). |
||||
|
Lectures: STII, room 7, 4:30 – 7:10 PM (see schedule below) |
||||
|
Professor's Office Hours: Thursday 4:30 – 6:00 PM |
||||
|
Teaching Assistant:
|
||||
|
Homework Submission Guideline: Read Me Please! |
|
Approximate Course Schedule: |
|
No |
Date |
Topic (chapter/section) |
HW assignment |
HW due |
Project due |
Slides |
|
1 |
Jan 27 |
Introduction (chapter 1) |
|
|
|
|
|
2 |
Feb 3 |
ER model (chapter 2) |
|
|
||
|
3 |
Feb 10 |
Relational Model (chapter 3) |
|
|
|
|
|
4 |
Feb 17 |
Relational Algebra (sections 4.1-4.2) |
hw2 |
1 |
|
|
|
5 |
Feb 24 |
Relational Algebra and Calculus |
|
|
|
|
|
6 |
March 3 |
SQL (sections 3.4, 5.1-5.5) |
hw3 |
2 |
|
|
|
7 |
Mar 10 |
Spring Break – no class |
|
|
|
|
|
8 |
Mar 17 |
review for Midterm |
3 |
|
||
|
9 |
Mar 24 |
Midterm |
hw4 |
|
|
|
|
10 |
Mar 31 |
SQL (sections 5.6-5.15) |
|
|
|
|
|
11 |
April 7 |
SQL (continued) |
|
|
Query selection due |
|
|
12 |
Apr 14 |
Relational design (chapter 15) |
4 |
|
||
|
13 |
Apr 21 |
Relational design (continued) |
|
|
|
|
|
14 |
Apr 28 |
Advanced topics (or catch up) |
|
5 |
Final Report due |
|
|
15 |
May 5 |
Review for final |
|
|
|
|
|
16 |
May 12 |
Final Exam |
|
|
|
|
|
|
|
|
|
|
General. Oracle database management system is installed in an IT&E Unix server, which is accessible from rooms ST2-12, ST2-133 and ST-137 (and also via network or modem). Accessing Oracle. To access Oracle, you must first establish an account in the IT&E Unix labs. In addition, you must establish an Oracle account. This is done by sending mail to the Oracle database administrator <oracle@ite.gmu.edu>. To verify that your account has been set, login to sun.ite.gmu.edu and type sqlplus. If you get the oracle prompt SQL>, your account is ready; otherwise, send mail to the Oracle administrator. Working with Oracle. Oracle 10g reference material, e.g., http://www.oracle.com/technology/products/database/oracle10g/index.html
|
|
|
|
Requirements: The students are expected
to attend all lectures and finish homework assignments on time. (The
assignment and due dates as noted above are approximate ones. The precise
dates will be given on the assignment sheets.) The students are also expected
to attend the two in-class examinations.