George Mason University
  Department of Computer Science

INFS 614 - Database Management

Dr. Jessica Lin

Fall 2012

 

HOME


Course Description

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.

Instructor:

Dr. Jessica Lin 

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

TA

 TBA
 Office: Engineering Building 4456

Classes

Tuesday
4:30-7:10pm
Nguyen Engineering Building 1103

Prerequisites:

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

Grading

Assignments: 20%
Project: 20%

Midterm: 25%
Final: 35%


Exams

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.


Textbooks

  Required: "Database Management Systems" 3rd Edition, by Ramakrishnan and Gehrke

 Recommended: Oracle 10g Programming: A Primer by Sunderraman, Addison-Wesley, 2008

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.



 Tentative Schedule