CS482

Week	Date	Topic	Notes	Presentation	Homework	Chapter
1	22-Aug-07	Introduction				1
	24-Aug-07
2	27-Aug-07	Relational algebra	ch2.pdf			2 & 3
	29-Aug-07
	31-Aug-07
3	3-Sep-07	Labor day				2 & 3
	5-Sep-07	Relational algebra/SQL
	7-Sep-07	Quiz on relational algebra
4	10/14-Sep-07	No class				3
5	17-Sep-07	SQL	examples in	PPTX or PDF		3
	19-Sep-07	SQL
	21-Sep-07	SQL
6	24-Sep-07	Quiz on SQL
	26-Sep-07	Advanced SQL				4
	28-Sep-07
7	1-Oct-07	E-R design				6
	3-Oct-07
	5-Oct-07
8	8-Oct-07	Midterm
	10-Oct-07					6
	12-Oct-07
9	15/17-Oct-07	No class
	19-Oct-07	Relational Database Design				7
10	22-Oct-07	Keys and FDs - Closure
	24-Oct-07	1NF and BCNF
	26-Oct-07	Decomposition to BCNF				7
11	29-Oct-07	3NF
	31-Oct-07
	2-Nov-07
12	5-Nov-07	4NF and MVDs	my note			7
	7-Nov-07	Application Design and Development		Exp of trigger	Exp of JDBC	8
	9-Nov-07	XML				10
13	12-Nov-07	Quiz 5
	14-Nov-07
	16-Nov-07
14	19/24-Nov-07	Thanksgiving holiday & Fall break
15	26-Nov-07	Extended Aggregation in SQL				18
	28-Nov-07	Data warehousing & mining	Cube, Rollup, Rank	windowing example
	30-Nov-07	Creating decision tree
16	2-Dec-07	Ming association rules
	4-Dec-07	Information retrieval	file1.txt	file2.txt	file3.txt	Program and Query
	6-Dec-07	Information retrieval
		Sample test	2004-02	2004-01	2005-01
			2005-02	2006-02	2006-03
		Summary	2007-01
		Homework solution	HW8	HW9	HW10
17	Exam week

CS482 - Slides and Notes