| Week |
Period |
Topics |
Reading Assignment |
Lab |
| #1 |
Lecture 1 |
Course introduction |
|
Lab 1: Introduction to Microsoft Access |
| Lecture 2 |
DBMS terminology |
Chapter 1 |
| #2 |
Lecture 1 |
Data Modeling |
|
Lab 2: Creating Relational Models in MS
Access - Quiz #1 |
| Lecture 2 |
Entity Relationship Diagrams |
Chapter 2 |
| #3 |
Lecture 1 |
IDEF1X and UML Diagrams |
|
Lab 3: ERDs and
IDEF1X diagrams |
| Lecture 2 |
The Data Modeling Process |
Chapter 3 |
| #4 |
Lecture 1 |
Sample Univ. DB Appl. |
|
Lab 4:
Access Forms - Quiz #2 |
| Lecture 2 |
The Relational DB Model |
Chapter 4 |
| #5 |
Lecture 1 |
Primary & Foreign Keys, Functional Dependencies |
|
Lab 5: Quiz #3 |
| Lecture 2 |
Normalization |
Chapter 5 |
| #6 |
Lecture 1 |
Database Design |
|
Lab 6: Quiz #4 |
| Lecture 2 |
1:1, 1:M, and M:N relations, etc. |
Chapter 6 |
| #7 |
Lecture 1 |
Structured Query Language (SQL) |
|
Lab 7: Quiz #5 |
| Lecture 2 |
SQL (cont.) |
Chapter 7 |
| #8 |
Lecture 1 |
SQL (cont.) |
|
Lab 8: Quiz #6 |
| Lecture 2 |
Using SQL in Applications |
Chapter 14 |
| #9 |
Lecture 1 |
Using SQL (cont.) |
|
Lab 9: Quiz #7 |
| Lecture 2 |
ODBC, JDBC |
Chapter 9 |
| #10 |
Lecture 1 |
Database Administration |
|
Lab 10: Final Project Review |
| Lecture 2 |
XML and Databases |
Chapter 13 |
| #11 |
Exam week |
Final exam |
|
|
