CS 550-001: Database Systems
Spring 2015
Professor Alex Brodsky
Office: Nguen Engineering Bldg 4418, Phone:(703) 993-1529, Fax:(703)993-1710
Email: brodsky@gmu.edu
Prerequisites:
CS 310, 330 or
INFS 501, 515, 519, SWE 510
or equivalent
Required textbook:
Database Systems,
2nd ed. by Kifer, Bernstein and Lewis, Addison Wesley
or
Database Management Systems, 3-rd ed. by Raghu Ramakrishnan & Johannes Gehrkem, McGraw-Hill.
Recommended:
Oracle 10g reference material, e.g., http://www.oracle.com/technology/products/database/oracle10g/index.html
On-Line Course
Resources:
GMU Blackboard (courses.gmu.edu) CS 550-001 (please check frequently, at least once weekly before class for announcements)
Lectures: Innovation
Hall 136
Monday 4:30 – 7:20 PM (see schedule below)
Professor's Office Hours: Thursday 3:30 – 5:00 PM (no need to schedule, but please call to verify before coming)
Teaching Assistant:
Rohan Khade
email: rkhade@masonlive.gmu.edu
TA Office hours: TBD
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 Blackboard announcements. The students are also expected to attend the two in-class examinations.
Project: Important dates are listed. See project assignment for details.
Computings Resources:
General. Oracle database management system is
installed in an IT&E Unix server, which is accessible online.
VPN and Oracle Account Setup and Access.
Go to the website, http://labs.ite.gmu.edu/index.php/Services/Services, to
follow the procedures to setup your VPN and Oracle account. First, you need to
install the VPN and make it work so that you can also access the DB at home or
your workplace. Then follow the procedure to get the Oracle account and access
it.
Working with
Oracle. Oracle
10g reference material, e.g., http://www.oracle.com/technology/products/database/oracle10g/index.html
Grading policy:The final grades assigned to the
students are based on their performance on homework assignments (15%), midterm
exam (34%), final exam (44%) and a semester-long project (7%). The score of 90%
or higher guarantees an A grade, of 75% or higher - a B grade, of 60% or higher
- a C grade. Late homework and projection submission is NOT allowed
Tentative Class Schedule
|
Date |
Topic |
Reading |
HW Assigned |
HW Due |
Project Assigned/Due |
|
1/26 |
Intro |
Chapter 1 |
|
|
|
|
2/2 |
ER Model |
Chapter 2 |
HA 1 |
|
|
|
2/9 |
ER & Relational Model |
Chapter 3 |
|
|
|
|
2/16 |
Relational Algebra |
Chapter 4 |
HA 2 |
HA 1 |
|
|
2/23 |
Relational Calculus |
Chapter 4 |
|
|
|
|
3/2 |
SQL-I |
Chapter 5.1 – 5.7 |
HA3 |
HA2 |
|
|
3/9 |
No class – Spring break |
Chapter 5.1 – 5.7 |
|
|
|
|
3/13 |
SQL-II |
|
|
|
|
|
3/16 |
Friday, extra class: Catch-up and review for midterm exam |
|
|
HA3 |
|
|
3/23 |
Midterm Exam |
|
|
|
Project assigned |
|
3/30 |
SQL-III |
Chapter 5.1 – 5.7 |
HA4 |
|
|
|
4/6 |
Schema Refinement and Normalization |
Chapter 15 |
|
|
|
|
4/13 |
Normalization - Cont. |
Chapter 15 |
|
|
|
|
4/20 |
Advanced topics |
TBD |
|
HA4 |
|
|
4/27 |
No class |
|
|
|
|
|
5/4 |
Catch-up and review for final exam |
|
|
|
Project report and code due |
|
5/11 |
Final exam |
|
|
|
|
|
|
|
|
|
|
|