INFS 614 - Database Management

News & Announcements

12/6 - Quiz 3 and Quiz 4 solutions.

12/6 - Solution to the SQL Practice Questions. Note Query #3 is separated into 2 parts.

11/27 - HW5 updated.

11/20 - HW5 Part I posted. Due 12/2. Part II will be due at the same time.

11/8 - HW4 (extra credit assignment) posted. Due 11/18. No late submission will be accepted.

10/19 - midterm topics

10/19 - Project description posted.

10/19 - Quiz 1 and Quiz 2 solutions are posted.

10/10 - Remove the last two queries from HW3, and add this one: "Find the total number of units that 'John Doe' has completed (i.e. if he received an F in a course, then the course does not count)."

10/7 - GROUP-BY queries will NOT be on the midterm.

10/7 - HW3 zipped file posted (including the testbed and instructions)

10/5 - HW3 posted (deadline 10/14).

9/17 - HW2 posted (deadline 9/30).

9/8 - Reminder: Tuesday is the last day to add/drop a class. If you did not meet the prerequisites requirement as stated on the website, unless you have gotten explicit permission from me to stay in the class, you will be force-dropped from the class. Please come to see me tomorrow afternoon if you have any questions. Also, if you have not turned in your SoP form, please do so by tomorrow. You will not receive a grade without the form.

9/5 - HW1 is posted (deadline 9/16).

9/2 - Please check your email for information regarding prerequisites requirement.

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.

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.

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.

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