Course Lecture Plan

Lecture notes from Earl Wagner (before the midterm)

Date	Lectures Topics	Notes	Reading	Assignment
Th 3/31	Class overview, Introduction to Database	[ppt]	Ch. 1
Tu 4/5	Entity-Relationship Model	[ppt]	Ch. 2
Th 4/7				Homework 1 out
Tu 4/12	Relational Data Model	[ppt]	Ch 3.1-3.3
Th 4/14				Homework 1 in, Project 1 out
Tu 4/19	Functional Dependencies	[ppt]	Ch. 3.4 -3.5	Homework 2 out
Th 4/21
Tu 4/26	Normal Forms, BCNF and 3NF	[ppt]	Ch. 3.6
Th 4/28	Midterm Review (discuss homework)	See discussions in slides above		Homework 2 in
Tu 5/3	Midterm
Th 5/5	Relational Algebra	[ppt]	Ch. 5
Tu 5/10				Project 1 in, Homework 3 out
Th 5/12				Project 2 out
Tu 5/17	SQL Queries	[ppt]	Ch. 6.1 - 6.4
Th 5/19				Homework 3 in, Homework 4 out
Tu 5/24
Th 5/26	SQL: Data Definition and Manipulation	[ppt] [xml.ppt]	Ch 6.5 – 6.6	Homework 4 in, Homework 5 out
Tu 5/31	SQL: Views, Constraints Semistructured Data/XML		Ch. 6.7
Th 6/2	Semistructured Data/XML, Review for final	[xml.ppt]	Ch. 9	Homework 5 in Project 2 in

Notes:

1. Reading refers to the required textbook unless denoted otherwise.
2. The lecture notes have incorporated course materials developed by Jeff Ullman (Stanford)