HOME

News & Announcements

11/20 - HW4 ALL posted (due date 12/1)

11/13 - HW4 Part I posted (due date 12/1)

10/29 - Project posted. (Phase 1: due 11/10, Phase 2: due 11/19, Phase 3: due 11/29, Phase 4 & Final report: due 12/15).

10/25 - Midterm topics can be found here.

10/11 - HW3 posted (due date 10/20).

9/27 - HW2 posted (due date 10/6).

9/11 - HW1 posted (due date 9/22).

9/10 - HW1 will be posted by tomorrow afternoon (Friday).

8/27 - 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/27 - IMPORTANT: Please see below for the prerequisites for this course.

Instructor:

Dr. Jessica Lin

Office: Engineering Building, Room 4419

Phone: 703-993-4693

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

Office Hours: Wednesday 1-3pm

Hanjo Jeong

Email: hjeong [AT] gmu [DOT] edu

Office Hours: Tuesday 1-3pm

Office: Engineering Building, Room 4456

Classes

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

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.10: Tree-Structured Indexing
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	9/1	Introduction (Ch. 1)	Intro
2	9/8	ER Model (Ch. 2)	ER
3	9/15	Relational Model (Ch. 3)	Relational Model (updated on 9/22)
4	9/22	Relational Algebra I (Sec. 4.1-4.2)	Relational Algebra I	HW1 due
5	9/29	Relational Algebra II	Relational Algebra II
6	10/6	Relational Calculus (Brief) SQL I (Sec. 3.4, 5.1-5.5)	Relational Calculus SQL I	HW2 due
7	10/13	No Class
8	10/20	SQL II/Midterm Review	SQL II	HW3 due
9	10/27	Midterm
10	11/3	SQL III / Database Programming	Database Programming
11	11/10	Functional Dependencies (Sec. 19.1-19.3)	Normalization I
12	11/17	Decomposition and Normal Forms (Sec. 19.4-19.6)	Normalization II
13	11/24	Normalization, con't	Normalization III
14	12/1	Intro to Indexing	Indexing	HW4 due
15	12/8	Final Exam
16	12/15	Project Due