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.

Here’s the procedure to drop (see also Calendar, p. 16 of your Course Bulletin):

A. Before September 24: you do not need instructor permission but must come by university extension office to fill out the paperwork.

B. After September 24 but before October 22: you need instructor permission but must first come to extension office to initiate the drop, then go to instructor for signature.

C. After October 22: Drops after this date are given only for “rare and urgent compelling non-academic reasons.” I do not consider their becoming “busy at work” a “rare and urgent non-academic reason.” If work causes them to need to drop after October 23, you must have a letter from your employer stating that their work conditions have changed substantially in its nature (e.g. increased travel, new position, required overtime, etc.).

D. UT students must have the signature of their dean’s office (Liberal Arts’ students are exempt from this policy) to drop a course at any time, since they needed it to take the course in the first place. This assures that the dean’s’ offices can monitor their students as they are supposed to.

Week	Day	Date	Topic	Reading Assignments Due before the class
1	Thu	2003-08-28	Introduction/Overview/Syllabus/Course Expectations Chapter 1: Introduction to Database Processing	Chapter 1 Text 1
2	Thu	2003-09-04	Chapter 1: Introduction to Database Processing Chapter 2: ER Data Modeling: Tools and Techniques	Chapter 1,2 Text 1
3	Thu	2003-09-11	Chapter 3: ER Data Modeling: Process and Examples Lab 1 Due	Chapter 3 Text 1
4	Thu	2003-09-18	Chapter 4: The Relational Model and Normalization Chapter 5: Database Design	Chapter 4,5 Text 1
5	Thu	2003-09-25	Chapter 5: Database Design Chapter 6: SQL Lab 2 Due Group Project Topic/Team Due	Chapter 6 Text 1
6	Thu	2003-10-02	Chapter 6: SQL
7	Thu	2003-10-09	Chapter 7: SQL in Applications Group Project Proposal Due Lab 3 Due	Chapter 7 Text 1
8	Thu	2003-10-16	Test 1	Chapter 7 Text 1 Test: All material in chapters 1 through 5
9	Thu	2003-10-23	Lab 4 Due 1-1 Team meetings (bring your Logical Model)	Attendance is required
10	Thu	2003-10-30	Stored Procedures Group Project Logical Model Due	Chapter 03 Text 2, Chapter 11 Text 1
11	Thu	2003-11-06	Triggers and Views Test 2 Lab 5 Due	Chapter 12 Text 2, Chapter 11 Text 1
12	Thu	2003-11-13	User and Security Management Chapter 8: Database Redesign	Attendance is required
13	Thu	2003-11-20	Chapter 9: Managing Multi-user Databases Chapter 15: Sharing Enterprise Data Group Project DDL Due	Chapter 9,15 Text 1
14	Wed	2003-11-26 Noon	Group Project Intra-Team Grades Due by email for all students
14	Thu	2003-11-27	Thanksgiving Holiday Elements Lab is closed on Thu,Fri,Sat,Sun
15	Thu	2003-12-04	Group Project Final Report due (Bound and electronic version) for all groups Group Project Presentation (15 min. each group) Demo (15 min. each group) (in PAI 5.38)	Attendance is required

Last Updated: 11/10/2003 9:57:01 PM