George Mason University

Department of Computer Science

CS 550: Database Systems

Fall 2016

Professor Jessica Lin


Course Description

An introduction to database management with focus on architecting databases and using them in applications. Topics to be covered include: data modeling with the Entity-Relationship model; the relational model and its formal languages; SQL and application programming and protocols; the theory of database design; object databases; and XML and Web data.

Class Time and Location

Thursday, 4:30-7:10 pm
Innovation Hall 136

Instructor

Dr. Jessica Lin
Office: Engineering Building 4419
Phone: 703-993-4693
Email: myfirstname [AT] cs [DOT] gmu [DOT] edu
Office Hours: Thursday 2-4pm

GTA

Qingzhe Li
Email: qli10 [AT] gmu [DOT] edu
Office Hours: Monday & Tuesday 3-4pm
Office: Engineering Building 4456

Prerequisites
  1. CS 310 (Data Structures) AND CS 330 (Formal Methods and Models), or
  2. INFS 501 (Discrete Mathematics), 515 (Computer Architectures/Organization), 519 (Program Design / Data Structures), AND SWE 510 (Object-oriented Programming in Java)
Prerequisites are strictly enforced!

Grading

Assignments: 15%
Project: 15%
Midterm: 30%
Final: 40%

Exams

There will be one midterm exam and one final exam covering lectures and readings. All exams are in class, closed-book. The final exam is comprehensive. Exams must be taken at the scheduled time and place, unless prior arrangement has been made with the instructor. Missed exams cannot be made up.

Textbooks

  1. (Required) Database Systems - An Application-Oriented Approach, Complete Version, 2nd Edition
    Kifer, Bernstein, and Lewis
    Addison-Wesley/Pearson, 2005
    ISBN-10: 0321268458
    ISBN-13: 9780321268457
  2. (Recommended) Oracle 10g Programming: A Primer
    Sunderraman
    Addison-Wesley, 2008
    ISBN-10: 0321463048
    ISBN-13: 978-0321463043

Honor Code Statement

The GMU Honor Code is in effect at all times. In addition, the CS Department has further honor code policies regarding programming projects, which are detailed here. Any deviation from the GMU or the CS department Honor Code is considered an Honor Code violation. All assignments for this class are individual unless otherwise specified.

Learning Disability Accommodation

If you have a documented learning disability or other condition which may affect academic performance, make sure this documentation is on file with the Office of Disability Services and then discuss with the professor about accommodations.

Tentative Schedule

Week
Date
Topic
Slide
Assigned
Due
Note
1
9/1
Introduction (Ch. 1, 2)
Intro



2
9/8
Relational and ER Models (Ch. 3, 4)
ER
(updated 09/19)
HW1

Slides updated on 9/19 to include solutions for exercises
3
9/15
Relational and ER Models
Relational Model 1
(updated on 09/19)


Slides updated on 9/19 to reflect the lecture progress
4
9/22
Relational Model, con't
Relational Algebra
Relational Model 2
Relational Algebra 1
HW1-2

HW1

5
9/29
Relational Algebra
Relational Algebra 2 HW2

HW1-2
Fixed error on slide #12 on 10/3
6
10/6
Relational Algebra
Relational Calculus
Relational Algebra 3
Relational Calculus
HW3
Project
HW2
HW3 testbed
7
10/13
SQL
SQL1



8
10/20
SQL
SQL2
HW3 (10/17 11:59pm)

9
10/27
Midterm


Project Phase 1
10
11/3
SQL
SQL3
HW4

11
11/10
Database programming
DB Programming

HW4

12
11/17
Schema Refinement & Normalization
Normalization 1

Project Phase 2
13
11/24
Thanksgiving (no class)




14
12/1
Normalization 2
Normalization 2 HW5


15
12/8
Normalization 3 / Final Review
Normalization 3


16
12/15
Final Exam (4:30-7:15pm)


HW5, Project Phase 3 & Report due on 12/12 (11:59pm)