INFS 614 - Database Management

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.
1. 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.

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.

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.

Textbook

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

HOME