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 |
2002-08-30 |
Introduction/Overview/Syllabus/Course
Expectations |
|
|
2 |
Mon |
2002-09-02 |
Labor Day holiday Elements Lab closed |
|
|
2 |
Fri |
2002-09-06 |
Chapter
1: File Systems and Databases |
Chapter
1 Text 1 |
|
3 |
Mon |
2002-09-09 |
Chapter
2: The Relational Database Model |
Chapter
2 Text 1 |
|
3 |
Fri |
2002-09-13 |
Chapter 2: The Relational Database Model |
|
|
4 |
Mon |
2002-09-16 |
Chapter
3: Entity Relationship (E-R) Modeling |
Chapter
3 Text 1 |
|
4 |
Fri |
2002-09-20 |
Chapter 4: Normalization of Database Tables Lab 1 Due
|
Chapter
4 Text 1 |
|
5 |
Mon |
2002-09-23 |
Chapter 5: SQL |
Chapter
5 Text 1 |
|
5 |
Fri |
2002-09-27 |
Chapter 5: SQL Lab 2 Due |
|
|
6 |
Mon |
2002-09-30 |
Chapter 5: SQL Group Project
Topic/Team Due
|
|
|
6 |
Fri |
2002-10-04 |
Test 1 |
All
materials in course upto Test 1 from the beginning of the course |
|
7 |
Mon |
2002-10-07 |
SQL Server Connectivity through Java SQL Server Import facility Group Project Proposal Due |
|
|
7 |
Fri |
2002-10-11 |
Stored
Procedures |
Chapter
11 Text 2 |
|
8 |
Mon |
2002-10-14 |
Triggers and Views |
Chapter
12 Text 2 |
|
8 |
Fri |
2002-10-18 |
User and Security Management Lab 3 Due |
Chapter
34 Reference
a) |
|
9 |
Mon |
2002-10-21 |
Chapter 13: The Data Warehouse Group Project Logical Model Due |
Chapter
13 Text 1 |
|
9 |
Fri |
2002-10-25 |
Chapter 13: The Data Warehouse |
|
|
10 |
Mon |
2002-10-28 |
Test 2
|
All
materials in course upto Test 2 from the beginning of the course |
|
10 |
Fri |
2002-11-01 |
Chapter 6: Database Design |
Chapter
6 Text 1 |
|
11 |
Mon |
2002-11-04 |
Chapter 7: The University Lab: Conceptual Design (optional, time permitting) Lab 4 and 5 Due
|
Chapter
7 Text 1 |
|
11 |
Fri |
2002-11-08 |
Chapter 8: The University Lab: Conceptual Design Verification, Logical Design, and Implementation (optional, time permitting) Group Project DDL
Due
|
Chapter
8 Text 1 |
|
12 |
Mon |
2002-11-11 |
Chapter 9 |
Chapter
9 Text 1 |
|
12 |
Fri |
2002-11-15 |
Chapter 9 |
|
|
13 |
Mon |
2002-11-18 |
Pop Quiz |
|
|
13 |
Wed |
2002-11-20 |
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 |
|
|
13 |
Fri |
2002-11-22 |
Group Project
Presentation I (15 min. each group)
Group Project Final Report due (Bound and electronic version) for all groups |
Attendance
is required |
|
14 |
Mon |
2002-11-25 |
Group Project
Presentation II
|
Attendance
is required |
|
14 |
Thu |
2002-11-28 |
Thanksgiving Holiday Elements Lab Closed |
|
|
14 |
Fri |
2002-11-29 |
Thanksgiving Holiday Elements Lab Closed |
|
|
14 |
Sat |
2002-11-30 |
Thanksgiving Holiday Elements Lab Closed |
|
|
14 |
Sun |
2002-12-01 |
Thanksgiving Holiday Elements Lab Closed |
|
|
15 |
Mon |
2002-12-02 |
Demo I (15 min. each group) (9.00 am – 10.00 am in PAI 5.38) |
Attendance
is required |
|
15 |
Fri |
2002-12-06 |
Demo II (9.00 am – 10.00 am in PAI 5.38) |
Attendance
is required |
Last Updated: 11/17/2002 10:20:50 PM