George Mason University
  Department of Computer Science

INFS 614 - Database Management

Dr. Jessica Lin

FALL 2008

Home | Schedule | Assignments | Resources



 News & Announcements

8/22 - The class is currently full. If you are unable to register for the class, you are welcome to attend and see if anyone drops later, but I cannot add you until then.

8/22 - Please read below about the prerequisites for this course.


Dr. Jessica Lin 

Office: Science & Technology II, Room 453

Phone: 703-993-4693

Email: jessica [AT] cs [DOT] gmu [DOT] edu

Office Hours: Monday 3-5pm 


 Huaming Liu
 Email: hliu5 [AT] gmu [DOT] edu
 Office: TBA

 Office Hours: TBA


Robinsons Hall B111


INFS 501, 515, 590 or equivalent. Prerequisites are strictly enforced.

Students from one of the following graduate programs: INFS, SWE, ISA

Please consult your acceptance letter. In order to enroll in INFS 614, you must satisfy ALL your foundation course requirements. For each foundation course, you must either (1) be waived from the course, or (2) have taken the course and received a grade B or better.

Students from other programs:

Please consult the description of the prerequisite courses in the university catalog. During the first class meeting, you will be asked to sign a form and provide a list of courses you have taken in the past that fulfill the prerequisites. Information you will need to bring to the first class meeting regarding the prerequisites include: course numbers, course titles, institution(s) where courses were taken, year(s), and final grades. All information will be verified. 


Assignments: 20%
Project: 15%
Quizzes: 5%
Midterm: 25%
Final: 35%


Quizzes will be given in the beginning of the class. They may or may not be announced in advance. The lowest quiz grade will be dropped at the end of the semester. There will be a midterm exam and a final exam covering lectures and readings (both will be in class, closed book). The final exam (comprehensive) includes topics covered in the entire semester. Exams must be taken at the scheduled time and place. Missed exams cannot be made up.

Honor Code Statement

Please be familiar with the GMU Honor Code. Any deviation from this is considered an Honor Code violation. All assignments for this class are individual unless otherwise specified.

Topics (Revised)
Ch.1: Overview of Database Systems
Ch.2: Introduction to Database Design
Ch.3: The Relational Model
Ch.4: Relational Algebra
Ch.5: SQL
Ch.19: Schema Refinement and Normal Forms

Note: If time permits, more chapters will be added.


"Database Management Systems" 3rd Edition
by Ramakrishnan and Gehrke

 Tentative Schedule
No Dates Topics Slides Notes
1 8/26 Introduction (Ch. 1) Lecture 1
2 9/2 ER Model (Ch. 2) Lecture 2
3 9/9 Relational Model (Ch. 3) Lecture 3  
4 9/16 Relational Algebra I (Sec. 4.1-4.2) Lecture 4 hw1 due
5 9/23 Relational Algebra II Lecture 5  
6 9/30 SQL I (Sec. 3.4, 5.1-5.5) Lecture 6 hw2 due
7 10/7 SQL II/Midterm Review      Lecture 7  
8 10/14 No Class     hw3 due
9 10/21 Midterm

10 10/28 SQL III
 Lecture 8
11 11/4 Functional Dependencies (Sec. 19.1-19.3)  Lecture 9 hw4 due
12 11/11 Decomposition and Normal Forms (Sec. 19.4-19.6) Lecture 10  
13 11/18 Review on Normalization Theory  Lecture 11
14 11/25 Advanced Topics Lecture 12
15 12/2 Review
16 12/9 Final Exam