Schedule & Notes

Date Title Links/Notes Reading
Course Overview
Database Basics Ch. 1
MLK Day – No Class  
Data Models Ch. 2
Database Design Ch. 8
Relational Databases Ch. 3
Relational Databases (conclusion)    "
Relational Algebra     "
Entity-Relationship Model Ch. 4
Team Formation
Entity-Relationship Model (conclusion)
(exercise) (answer)
   "
Project Introduction
Entity-Relationship Model II
   "
Entity-Relationship Model exercises     "
Presidents' Day – No Class
Normalization Ch. 5
Normalization examples
Review
   "
Exam 1
Normalization examples
(exercise)  (answer)
Exam Discussion
   "
Data Model Validation  (paper)
Access Validation
 
Spring Break
Spring Break
SQL Ch. 6
SQL (conclusion)
(SQL Reference from ZDNet – Part I)  Word version
   "
Advanced SQL Ch. 6,7
Advanced SQL (conclusion)    "
SQL Exercises   solution      "
Advanced SQL
(SQL Reference from ZDNet–Part II)  Word version
Easy SQL Exercises (Individual)  mdb95  mdb2000  mdb2000  solution
   "
Project Discussion 
Multi-user Databases  Ch. 9
Multi-user Databases (conclusion)    "
Distributed Database Systems  Ch. 10
Project Discussion  
Distributed Database Systems (conclusion)    "
Graduate Presentations
     Ana Hueftle
     Karin Mithamo ppt 
SQL Injection Attacks
DB and VB
Review
Final Exam
Section 01 – Monday 5/9 12:30 PM - 2:30 PM
Section 02 – Monday 5/9   5:30 PM - 7:30 PM