HOME

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.

Instructor:

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

Classes

Tuesdays
4:30-7:10pm
Robinsons Hall B111

Prerequisites:

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.

Grading

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

Exams

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.

Textbook

"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	Review
16	12/9	Final Exam