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	2003-08-29	Introduction/Overview/Syllabus/Course Expectations
2	Mon	2003-09-01	Labor Day holiday Elements Lab closed
2	Fri	2003-09-05	Chapter 1: Introduction to Database Processing	Chapter 1 Text 1
3	Mon	2003-09-08	Chapter 1: Introduction to Database Processing Chapter 2: ER Data Modeling: Tools and Techniques	Chapter 2 Text 1
3	Fri	2003-09-12	Chapter 2: ER Data Modeling: Tools and Techniques Lab 1 Due
4	Mon	2003-09-15	Chapter 3: ER Data Modeling: Process and Examples	Chapter 3 Text 1
4	Fri	2003-09-19	Chapter 4: The Relational Model and Normalization	Chapter 4 Text 1
5	Mon	2003-09-22	Chapter 4: The Relational Model and Normalization Lab 2 Due
5	Fri	2003-09-26	Chapter 5: Database Design	Chapter 5 Text 1
6	Mon	2003-09-29	Chapter 5: Database Design Group Project Topic/Team Due
6	Fri	2003-10-03	Chapter 6: SQL	Chapter 6 Text 1
7	Mon	2003-10-06	Chapter 6: SQL
7	Fri	2003-10-10	Test 1 Group Project Proposal Due	All material in chapters 1 through 5
8	Mon	2003-10-13	Chapter 6: SQL Lab 3 Due
8	Fri	2003-10-17	1-1 Team meetings (bring your Logical Model)	Attendance is required
9	Mon	2003-10-20	Chapter 6: SQL Lab 4 Due
9	Fri	2003-10-24	Chapter 7: SQL in Applications Group Project Logical Model Due	Chapter 7 Text 1
10	Mon	2003-10-27	Chapter 8: Database Redesign	Chapter 8 Text 1
10	Fri	2003-10-31	Stored Procedures Lab 5 Due
11	Mon	2003-11-03	Test 2	All materials in course up to Test 2 from the beginning of the course
11	Fri	2003-11-07	Triggers and Views
12	Mon	2003-11-10	User and Security Management	Chapter 34 Reference a)
12	Fri	2003-11-14	Chapter 9: Managing Multi-user Databases Group Project DDL Due	Chapter 9 Text 1
13	Mon	2003-11-17	Chapter 9: Managing Multi-user Databases
13	Fri	2003-11-21	Chapter 15: Sharing Enterprise Data	Chapter 15 Text 1
14	Mon	2003-11-24	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	Thu - Sat	2003-11-27 till 2003-11-29	Thanksgiving Holiday Elements Lab closed
15	Mon	2003-12-01	Group Project Presentation I (15 min. each group)	Attendance is required
15	Fri	2003-12-05	Group Project Final Report due (Bound and electronic version) for all groups Group Project Presentation II Demo II (15 min. each group) (10.00 am–11.45 am in PAI 5.38)	Attendance is required

Last Updated: 11/24/2003 10:17:40 PM