News
& Announcements |
2/2:
HW1
posted.
2/20: HW2 posted.
3/7: Project posted.
3/9: HW3 posted. Here is a sample testbed.
4/21: 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: Thursday 2-4pm
Classes
Thursday
4:30-7:10pm
Robinson Hall B113
Prerequisites:
INFS 501, 515, 519, and SWE 510, or equivalent.
Prerequisites are strictly enforced.
Grading
Quiz: 15%
Project: 25%
Midterm: 25%
Final: 35%
Assignments
There will be four assignments. However, the
assignments will not be
graded.
Exams
There will be 5 quizzes, a midterm exam and a final
exam covering
lectures and
readings (in class, closed book). The final exam
(comprehensive) 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.
Honor Code
Statement
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.
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 |
1/24
|
Introduction (Ch. 1)
ER Model 1 (Ch. 2) |
Introduction
ER
1
|
|
2 |
1/31
|
ER Model 2
Relational
Model 1 (Ch. 3) |
ER
2
|
HW1
posted
|
3 |
2/7 |
Relational Model 2
|
Relational
Model
|
|
4 |
2/14 |
Relational Algebra 1 (Ch. 4)
|
Relational Algebra 1
|
HW1
due
|
5 |
2/21 |
Relational Algebra 2
|
Relational Algebra 2
|
HW2 posted
|
6 |
2/28
|
SQL 1 (Ch. 5)
|
SQL 1
|
|
7 |
3/7 |
SQL 2 |
SQL 2
|
HW2 due, HW3 posted (see testbed above)
|
8 |
3/14 |
Spring Break
|
|
|
9 |
3/21 |
Midterm
review
|
|
HW3 due
Project Phase 1 due
Quiz 3
|
10 |
3/28 |
Midterm |
|
|
11 |
4/4 |
SQL 3
SQL 4 (Constraints & Triggers)
|
SQL 3
SQL 4
|
|
12 |
4/11 |
Database Programming (Ch. 6) |
Database Programming
|
Project Phase 2 due
|
13 |
4/18 |
Functional
Dependencies (Ch. 19)
|
Normalization 1
|
HW4 posted
Quiz 4
|
14 |
4/25 |
Decomposition and Normal Forms 1 (Ch. 19)
|
Normalization 2
|
Quiz 5
|
15 |
5/2 |
Decomposition and Normal Forms 1
Final Review
|
|
HW4 due
Project demo
Project report due
|
16 |
5/9 |
Final
Exam (4:30-7:15pm) |
|
|
|