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