SCHEDULE for CS 4707
The schedule indicates the concepts and material to be (un)covered in each
week under the column labeled "Topics". The chapters in the textbook are
referred to by the chapter number or Appendix number.
Homeworks will be due on Tuesdays of designated weeks.
Mid-term examinations will take one
meeting in designated weeks. Other meeting
may be used for discussions.
| Week | Dates |
Lecture Topics |
Textbook | Supplement |
Due | Feedback |
| 1 | 9/3-5 |
Introductions |
1 | |
| |
| 2 | 9/10-12 |
Relational Model |
2 | |
| |
| 3 | 9/17-19 |
SQL - 1 |
3 | |
| |
| 4 | 9/24-26 |
SQL - 2 |
4 | |
HW 1 | |
| 5 | 10/1-3 |
Database Design |
5 | |
HW 2 | HW 1 |
| 6 | 10/8-10 |
Data Modeling |
7 | |
| HW 2 |
| 7 | 10/15-17 |
Normalization |
| |
| 8 | 10/22-24 |
Discussion |
| |
MS Exam | |
| 9 | 10/29-31 |
Physical DB Design |
10 | |
| MS Exam |
| 10 | 11/5-7 |
DBMS Administration |
12 | |
HW 3 | |
| 11 | 11/12-14 |
Data Warehouses |
14 | |
| HW 3 |
| 12 | 11/19-21 |
Object DBMSs |
16 | |
HW 4 | |
| 13 | 11/26 |
Review |
| |
| |
| 14 | 12/3-5 |
Client Server DBMSs |
15 | |
| HW 4 |
| 15 | 12/10-12 |
TBD, Summary |
| |
| |
| 16 | 12/16-20 |
Final Exam. |
Tu 12/17 130-330pm | |
| |
Active group learning techniques
may be used in class meetings to enhance the learning opportunities.
Performance of a student during these exercises
will have no bearing on his/her grades. Students will work in a small group
of two or three on an exercise or a discussion question provided in the
class meeting. After this, a randomly chosen student will be invited to
summarize the discussion in his/her group. Other students in the class
may paraphrase and improve the presented material.