Database Fundamentals

Topic	Material	Due	Solutions
Database environment	Chap 1
Database development process	Chap 2
Database modeling	Chap 3
Labor day holiday: no class
Database modeling	Chap 3	Assignment 1 (Chap1, 2)	Assignment 1
Enhanced E-R model	Chap 4
Logical database design	Chap 5	Assignment 2 (3, 4)	Assignment 2
Logical database design	Chap 5
Physical design	Chap 6
Introduction to SQL	Chap 7	Assignment 3 (5, 6)	Assignment 3
SQL lab 1 – demo	SQL lab 1
SQL lab 2 – Assignment 4
Midterm review	Midterm review	Assignment 4 (7)	Assignment 4
Midterm exam preparation: no class
Midterm exam			Midterm exam
Group project	Group project
Advanced SQL	Chap 8
SQL lab 3 – demo	SQL lab 3
SQL lab 4 – Assignment 5		Assignment 5 (8)	Assignment 5
Project plan presentations		Project Plan
Client/server database	Chap 9
Access lab 1	Access lab 1 Handout
Internet database environment	Chap 10
Access lab 2	Access lab 2 Handout	Assignment 6 (9)	Assignment 6
Data warehousing	Chap 11
Group project meeting time
Group project meeting time
Database administration and Distributed database	Chap 12 Chap 13
Project preparation: lab Q&A
Project presentations		Project Report