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
|