CS 450-001: Database Management

Spring 2014

Professor Alex Brodsky

Office: Nguen Engineering Bldg 4418, Phone:(703) 993-1529, Fax:(703)993-1710

Email: brodsky@gmu.edu


Prerequisites: 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

Required textbook (1 of the following):

1.    Database Systems, 2nd ed. by Kifer, Bernstein and Lewis, Addison Wesley


2.    Database Management Systems, 3-rd ed. by Raghu Ramakrishnan & Johannes Gehrkem, McGraw-Hill


3.    Fundamentals of Database Systems, by Elmasri and Navathe,4th ed., Addison Wesley, 2004

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 450-001 (please check frequently, at least once weekly before class for announcements)

Lectures: Art and Design Building L008

                  Wednesday 1:30 – 2:45 PM (see schedule below)

Professor's Office Hours: Thursday 4:00 – 5:30 PM (no need to schedule, but please call to verify before coming)


Teaching Assistant: Shalini Bavanaka

Office hours: Tuesday 5:00 – 7:00 PM


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 (16%), midterm exam (33%), 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 project submission is NOT allowed. A submission is considered on time if submitted before electronically on Blackboard on or before required submission date/time.


Tentative Class Schedule



Reading (Ramakrishnan)

HW Assigned

HW Due

Project Due

Thu, 1/23


Chapter 1




Tue, 1/28

ER Model

Chapter 2

HA 1



Thu, 1/30






Tue, 2/4

ER & Relational Model





Thu, 2/6






Tue, 2/11

Relational Algebra

Chapter 4

HA 2

HA 1


Thu, 2/13






Tue, 2/18

Relational Calculus

Chapter 4




Thu, 2/20






Tue, 2/25


Chapter 5.1 – 5.7




Thu, 2/27






Tue, 3/4

Catch-up and review





Thu, 3/6

Midterm Exam




Project Assigned

Tue, 3/11

No class – Spring break





Thu, 3/13


No class – Spring break





Tue, 3/18


Chapter 5.1 – 5.7




Thu, 3/20






Tue, 3/25






Thu, 3/27






Tue, 4/1






Thu, 4/3






Tue, 4/8

Schema Refinement and Normalization

Chapter 15

HA 4


Preliminary Project Submission

Thu, 4/10






Tue, 4/15






Thu, 4/17






Tue, 4/22






Thu, 4/24






Tue, 4/29

No Class – work on projects



HA 4


Thu, 5/1

No Class – work on projects





Tue, 5/6

Optional Catch-up and Review




Final Project Submission

Thu, 5/8

Advanced Topics





Tue, 5/13

Final Exam