CS 550-001: Database Systems

Spring 2016

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: Art and Design Building, 2026

Tuesdays 7:20-10:00 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:

Yuyang Gao

email:

ygao13@masonlive.gmu.edu

TA Office hours: Monday 4 5:30; Thursday 4 5:30

 

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/19

Intro

Chapter 1

 

 

 

1/26

ER Model

Chapter 2

HA 1

 

 

2/2

ER & Relational Model

Chapter 3

 

 

 

2/9

Relational Algebra

Chapter 4

HA 2

HA 1

 

2/16

Relational Calculus

Chapter 4

 

 

 

2/23

SQL-I

Chapter 5.1 – 5.7

HA3

HA2

 

3/1

SQL-II

Chapter 5.1 – 5.7

 

 

 

3/8

No class – Spring break

 

 

 

 

3/15

Catch-up and review for midterm exam

 

 

HA3

 

3/22

Midterm Exam

 

 

 

Project assigned

3/29

SQL-III

Chapter 5.1 – 5.7

HA4

 

 

4/5

Schema Refinement and Normalization

Chapter 15

HA5

HA4

 

4/12

Normalization - Cont.

Chapter 15

 

 

 

4/19

Advanced topics

TBD

 

HA5

 

4/26

Catch-up and review for final exam

 

 

 

Project report and code due

5/3

Final exam