INFS 614 - Database Management

News & Announcements

8/30: If you added the class after 8/25, or if you have not received a Welcome email from Piazza, please let me know.

8/30: HW1 posted. Note the new deadline (9/17).

9/7: Reminder: Quiz next Tuesday (9/10). Here is a sample quiz.

9/7: Note the extended office hours for the TA and the location.

9/13: Project posted.

9/19: HW2 posted.

9/20: Reminder: Quiz next Tuesday (9/24). Here is a sample quiz.

9/20: HW1 solution

10/4: Project Phase 2 deadline is postponed by one week. New deadline: 10/22

10/4: HW2 solution

10/4: HW3 posted. Here is the testbed.

10/7: Reminder: Quiz tomorrow (10/8). Here is a sample quiz.

10/18: Project Phase 1 solution.

10/25: Sample midterm

10/28: HW3 solution

11/5: Project Phase 3 information and sample JDBC program. Change the lines with the username and password by entering your own Oracle username/password, compile, and run the program.

11/21: HW4 posted.

11/25: Reminder: Quiz tomorrow (11/26). Here is a sample quiz.

12/7: HW4 solution

Introduces database systems, emphasizing study of database models and languages and practice of database design and programming. Topics include Entity-Relationship model, relational model and its formal query languages, SQL, theory of relational database design, and object-oriented and logic-based databases.

Office: Engineering Building 4419
Phone: 703-993-4693
Email: jessica [AT] cs [DOT] gmu [DOT] edu
Office Hours: Tuesday/Thursday 3-4pm

INFS 501, 515, 519, and SWE 510, or equivalent. Prerequisites are strictly enforced.

There will be 4 quizzes, a midterm exam and a final exam covering lectures and readings (in class, closed book). The final exam is comprehensive, and it includes topics covered in the entire semester. With the exception of the quizzes, which must be taken at the time they are given, prior arrangement needs to be made with the instructor if you cannot make it to the exam. Missed exams cannot be made up.

Please be familiar with the GMU Honor Code. In addition, the CS department has its own Honor Code policies. Any deviation from this is considered an Honor Code violation.

If you are a student with a disability and you need academic accommodations, please see me and contact the Office of Disability Services (ODS) at 993-2474, http://ods.gmu.edu. All academic accommodations must be arranged through the ODS.

Textbooks

Tentative Topics

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.6: Database Application Development
Ch.10: Tree-Structured Indexing
Ch.19: Schema Refinement and Normal Forms

Note: If time permits, more chapters will be added.

HOME