George Mason University
  Department of Information and Software Engineering

INFS 614 - Database Management

Dr. Jessica Lin

FALL 2007

Home | Schedule | Assignments | Resources



 News & Announcements
12/9 - HW4 solution posted.

12/3 - Quiz3 solution and Quiz4 solution posted.

12/3 - Final topics posted.

12/3 - Midterm solution posted.

11/16 - HW 4 posted. Due date 12/6 before 7pm.

11/15 - Project query selection posted (due date changed to 11/27)

11/5 - HW3 and Project topic selection due date postponed until 11/8

11/1 - HW 3 Testbed posted.

10/28 - HW 2 solution posted.

10/28 - Midterm Prob 3 solution posted.

10/26 - HW 3 posted (due date 11/6).

10/23 - Project topic selection posted (due date 11/6).

10/19 - Re-test on Problem 3 next Tuesday (10/30)

10/15 - HW2 deadline extended until Thursday (10/18) before midnight.

10/12 - Quiz 2 solution posted.

10/8 - Please check your GMU email for midterm information.

10/5 - Please change Problem 2, #8 to "Find the art group, if any, that's liked by ALL customers." The original question is not expressable in Relational Algebra/Calculus!

9/26 - HW 2 posted (due date: 10/16 in class).

9/25 - Quiz 1 solution posted.

9/5 - HW 1 posted (due date: 9/18 in class). Please read the submission guide.

9/3 - More on prerequisites: If you answer yes to ALL of the following conditions, please bring your transcript and class syllabus (if the title of the class does not clearly state that it's equivalent to our prerequisite courses). You must get a B or better, or equivalent, in those prerequisite classes.
Your undergraduate degree is NOT computer science.
  2. You are not an ISE nor CS student.
  3. You took the prerequisite classes from a university outside of the U.S.
  ISE students who have not been waived from the foundation courses are NOT allowed to take this class.

 8/31 - If you haven't filled out the Satisfaction of Prerequisite form, please do so and bring it to the class on Tuesday. For descriptions on the prerequisite courses (INFS 501, 515, and 590), see here.


Dr. Jessica Lin 

Office: Science & Technology II, Room 453

Phone: 703-993-4693

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

Office Hours: Monday 4-6pm 


 Huaming Liu
 Email: hliu5 [AT] gmu [DOT] edu
 Office: Science & Technology II, Room 432

 Office Hours: Wednesday 2-4pm


Innovation Hall 105


INFS 501, 515, 590 or equivalent.


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 and Calculus
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
18/28Introduction (Ch. 1)Lecture 1slides last updated 4:52pm, 8/28
29/4ER Model (Ch. 2)Lecture 2slides last updated 9/5
39/11Relational Model (Ch. 3)Lecture 3 
49/18Relational Algebra (Sec. 4.1-4.2)Lecture 4 hw1 due
59/25Relational Calculus (Sec. 4.3-4.4)Lecture 5 
610/2SQL (Sec. 3.4, 5.1-5.5)Lecture 6 
710/9No Class    
810/16Midterm    hw2 due
910/23Relational Algebra/Calculus review Lecture 7Lecture 7 slides are mostly the same as Lecture 5. Lecture 6 slides will also be used.
1010/30SQL, con't
 Lecture 8Midterm re-test on Problem 3
1111/6Functional Dependencies (Sec. 19.1-19.3) Lecture 9Project topic selection due

hw3 due (hw3 testbed)
1211/13Decomposition and Normal Forms (Sec. 19.4-19.6)Lecture 10 
1311/20Review on Normalization Theory Lecture 11
1411/27Database Programming & Transaction Management Overview (Sec 6.1-6.3, 16.1, 16.6, 21.3)Lecture 12 Query selection due
1512/4Review hw4 due on 12/6 by 7pm
1612/11Final Exam  Final report due