CSC 3800-01: Datebase Management Systems—C
Fall 2008
MF 10:00 – 11:15
Science 12356
Assignments
Textbook: Ullman and Widom, A
First Course in Database Sysems, 3rd
Edition, 2008
|
Meeting Date |
Meeting Day |
Text Chapter(s) |
Lesson |
Slides |
Homework &
Programs Due |
|
8/22/2008 |
Friday |
Introduction &
Ch 1 |
Class Overview & Ch 1 |
|
|
|
8/25/2008 |
Monday |
No Class |
No Class |
|
|
|
8/29/2008 |
Friday |
Chapter 2 |
2.1 – 2.3 |
|
|
|
9/1/2008 |
Monday |
|
Labor Day |
|
|
|
9/5/2008 |
Friday |
Chapter 2 |
2.4 – 2.5 |
|
2.2.1, 2.3.1 |
|
9/8/2008 |
Monday |
Chapter 6.1, 6.2 |
Introduction to SQL |
2.4.1, 2.5.1 |
|
|
9/12/2008 |
Friday |
Chapter 6.3 |
Subqueries |
|
|
|
9/15/2008 |
Monday |
Chapter 5.2 |
Extended Relational Algebra |
|
|
|
9/19/2008 |
Friday |
Chapter 6.4, 6.5 |
Full Relational Operatons, Database Modificatons |
|
|
|
9/22/2008 |
Monday |
Chapter 7.1 – 7.3 |
Keys, Foreign Keys, Constraints |
5.2.1 |
|
|
9/26/2008 |
Friday |
Chapter 7.4, 7.5 |
Assertions & Triggers |
07host-psm-plsql |
6.1.2, 6.2.1, 6.3.1, 6.4.1, 6.5.1 |
|
9/29/2008 |
Monday |
Chapter 6.6 |
SQL Transactions |
06trans-view-index |
7.1.1, 7.2.1, 7.3.1, 7.4.1, 7.5.2 |
|
10/3/2008 |
Friday |
Review for Mid Term |
|
|
6.6.1 |
|
10/6/2008 |
Monday |
Mid Term Exam |
|
|
|
|
10/10/2008 |
Friday |
|
Fall Break |
|
|
|
10/13/2008 |
Monday |
Chapter 8.1-8.3 |
Views |
06trans-view-index |
|
|
10/17/2008 |
Friday |
Chapter 8.4-8.5 |
Indexes |
06trans-view-index |
|
|
10/20/2008 |
Monday |
Chapter 9.3, 9.4 |
Embedded SQL |
08cli-jdbc-php |
8.1.1, 8.2.3, 8.3.1, 8.4.1, 8.5.1 |
|
10/24/2008 |
Friday |
Chapter 9.1, 9.2 |
SQL in Server Environment |
08cli-jdbc-php |
|
|
10/27/2008 |
Monday |
Chapter 9.5 – 9.7 |
SQL in Server Environment |
08cli-jdbc-php |
|
|
10/31/2008 |
Friday |
Chapter 3.1 – 3.3 |
Functional Dependencies, Normalization |
11fds |
|
|
11/3/2008 |
Monday |
Chapter 3.4 – 3.5 |
Inference of Dependencies, |
11fds |
|
|
11/7/2008 |
Friday |
Chapter 3.6, 3.7 |
Multivalued Dependencies, 3NF, 4NF |
12mvds |
|
|
11/10/2008 |
Monday |
Chapter 4.1 – 4.3 |
Entity/Relationship Model |
13er |
3.1.3, 3.2.1, 3.3.1, 3.4.1, 3.4.5, 3.6.2, 3.7.1 |
|
11/14/2008 |
Friday |
Chapter 4.4 – 4.6 |
More E/R |
13er |
|
|
11/17/2008 |
Monday |
Chapter 4.7 – 4.10 |
UML, ODL |
14uml-odl |
|
|
11/21/2008 |
Friday |
Chapter 9 & Project |
|
|
4.5.1, 4.6.1, 4.1.1., 4.2.4, 4.3.1(a), 4.4.4, 4.7.1, 4.8.1, 4.9.1, 4.10.1(a) |
|
11/24/2008 |
Monday |
Chapter 9 & Project |
|
|
Project Components |
|
11/28/2008 |
Friday |
Holdiay |
Thanksgivings |
|
|
|
12/1/2008 |
Monday |
Chapter 9 & Project |
|
|
Project Components |
|
12/5/2008 |
Friday |
Review for Final Exam |
|
|
Project Components |
|
12/8/2008 |
Monday |
10:45 – 1:15 |
Final Exam |
|
|
Updated September 18, 2008 | lilliec@uncp.edu
Contact Web Page Owner at lilliec@uncp.edu