HOME

News & Announcements

9/4 - HW1 posted. Due date is 9/18.

9/20 - HW2 posted. Due date is 10/2.

9/23 - HW2 corrected. The only change is the primary key for the Transaction relation (it should be transaction_ID and UPC).

9/30 - HW1 solution posted on Blackboard

10/1 - Project posted. Note: Phase 1 is due on 10/16.

10/4 - HW3 posted. Due date is 10/23.

10/9 - HW3 testbed posted.

11/21 - Guideline for Phase 3 posted.

11/28 - HW4 posted

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

Venkata Yerneni
Email: vyerneni [AT] gmu [DOT] edu
Office Hours: Thursday 5-7pm
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

No	Dates	Topics	Slides	Notes
1	8/28	Introduction (Ch. 1) ER Model 1 (Ch. 2)	Introduction ER1
2	9/4	ER Model 2 Relational Model 1 (Ch. 3)	ER2 Relational Model 1	HW1 posted
3	9/11	Relational Model 2	Relational Model 2
4	9/18	Relational Algebra 1 (Ch. 4)	Relational Algebra 1	HW1 due HW2 posted
5	9/25	Relational Algebra 2	Relational Algebra 2
6	10/2	SQL 1 (Ch. 5)	SQL 1	HW2 due HW3 posted
7	10/9	No Class
8	10/16	SQL 2	SQL 2	Project phase 1 due
9	10/23	Midterm review SQL 3	SQL 3	Phase 1 returned HW3 due
10	10/30	Class Canceled
11	11/6	Midterm
12	11/13	Post-midterm review Database Programming (Ch. 6)	DB Programming	Project phase 2 due
13	11/20	Functional Dependencies (Ch. 19)	Normalization 1
14	11/27	Decomposition and Normal Forms 1 (Ch. 19)	Normalization 2	HW4 posted
15	12/4	Decomposition and Normal Forms 2	Normalization 3
16	12/11	Final Review		HW4 due Project & report due
17	12/18	Final Exam (4:30-7:15pm)