NOTE: The dates for the classes are tentative, and subject to change anytime by the instructor. Please finish the reading assignment before the class due date. All assignments/projects are due at the beginning of the class on the date they are due. If changes in the schedule are necessary, students will be held responsible for such changes, which will be announced in class. All Chapters relate to the text 1 and text 2 for this course.

Consult the registrar’s office for other relevant dates.

Week	Day	Date	Topic	Reading Assignments Due before the class
1	Fri	2004-01-23	Introduction/Overview/Syllabus/Course Expectations	Class Web site
2	Mon	2004-01-26	Chapter 1: Introduction to Database Processing	Chapter 1
2	Fri	2004-01-30	Chapter 1: Introduction to Database Processing Chapter 2: ER Data Modeling: Tools and Techniques	Chapter 2
3	Mon	2004-02-02	Chapter 2: ER Data Modeling: Tools and Techniques Lab 1 Due
3	Fri	2004-02-06	Chapter 3: ER Data Modeling: Process and Examples	Chapter 3
4	Mon	2004-02-09	Chapter 4: The Relational Model and Normalization	Chapter 4
4	Fri	2004-02-13	Chapter 4: The Relational Model and Normalization
5	Mon	2004-02-16	Chapter 5: Database Design Lab 2 Due	Chapter 5
5	Fri	2004-02-20	Chapter 5: Database Design
6	Mon	2004-02-23	Chapter 6: SQL Group Project Topic/Team Due Lab 3 Due	Chapter 6
6	Fri	2004-02-27	Test1	Attendance is Mandatory for all students
7	Mon	2004-03-01	Chapter 6: SQL Group Project Proposal Due
7	Fri	2004-03-05	Chapter 6: SQL
8	Mon	2004-03-08	Chapter 6: SQL
8	Fri	2004-03-12	1-1 Team meetings (bring your Logical Model Draft)	Group Meeting in PAI 5.44 Attendance is Mandatory for all students
	Mon-Fri	2004-03-15 2004-03-19	Spring Break Elements Lab Closed
9	Mon	2004-03-22	Chapter 6: SQL
9	Fri	2004-03-26	Triggers and Views Group Project Logical Model Due
10	Mon	2004-03-29	Chapter 7: SQL in Applications Lab 4 Due	Chapter 7
10	Fri	2004-04-02	Stored Procedures
11	Mon	2004-04-05	Test2	Attendance is Mandatory for all students
11	Fri	2004-04-09	Lab 5 Due User and Security Management
12	Mon	2004-04-12	Chapter 9: Managing Multi-user Databases	Chapter 9
12	Fri	2004-04-16	Chapter 9: Managing Multi-user Databases Group Project DDL Due
13	Mon	2004-04-19	Chapter 15: Sharing Enterprise Data	Chapter 15
13	Fri	2004-04-23	Chapter 15: Sharing Enterprise Data Group Project PowerPoint presentation Due by email by 5.00pm for all groups Group Project Intra-Team Grades Due by email by 5.00pm for all students
14	Mon	2004-04-26	Group Presentation I	Attendance is Mandatory for all students
14	Fri	2004-04-30	Group Presentation II	Attendance is Mandatory for all students
15	Mon	2004-05-03	Group Project Final Report due (Bound and electronic version) for all groups Demo I + II	Attendance is Mandatory for the group during their demo
15	Fri	2004-05-07

Last Updated: 3/26/2004 11:59:45 AM