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-08-27

Introduction/Overview/Syllabus/Course Expectations

Class Web site

2

Mon

2004-08-30

Chapter 1: Introduction to Database Processing

Chapter 1

2

Fri

2004-09-03

Chapter 1: Introduction to Database Processing

Chapter 2: ER Data Modeling: Tools and Techniques

Chapter 2

3

Mon

2004-09-06

Labor Day Holiday

 

3

Fri

2004-09-10

Chapter 2: ER Data Modeling: Tools and Techniques

Lab 1 Due

 

3

Fri

2004-09-10

Deadline: Dropping a class with possible refund.

 

4

Mon

2004-09-13

Chapter 3: ER Data Modeling: Process and Examples

Chapter 3

4

Fri

2004-09-17

Chapter 4: The Relational Model and Normalization

Chapter 4

5

Mon

2004-09-20

Chapter 4: The Relational Model and Normalization

 

5

Wed

2004-09-22

Deadline: Dropping a class without possible academic penalty. No Refund.

 

5

Fri

2004-09-24

Chapter 5: Database Design

Lab 2 Due

Chapter 5

6

Mon

2004-09-27

Chapter 5: Database Design

 

6

Fri

2004-10-01

Chapter 6: SQL

Group Project Topic/Team Due

Chapter 6

7

Mon

2004-10-04

Lab 3 Due

Chapter 6: SQL

 

7

Fri

2004-10-08

Chapter 6: SQL

Group Project Proposal Due

 

8

Mon

2004-10-11

Test 1

Attendance is Mandatory for all students

8

Fri

2004-10-15

Chapter 6: SQL

 

9

Mon

2004-10-18

1-1 Team meetings (bring your Logical Model Draft)

Group Meeting in PAI 5.44

Attendance is Mandatory for all students

9

Wed

2004-10-20

Deadline: Last day to drop a class with approval.

 

9

Fri

2004-10-22

Chapter 6: SQL

 

10

Mon

2004-10-25

Chapter 6: SQL

Group Project Logical Model Due

 

10

Fri

2004-10-29

Chapter 6: SQL

 

11

Mon

2004-11-01

Chapter 7: SQL in applications

Chapter 7

11

Fri

2004-11-05

Chapter 7: SQL in applications

 

12

Mon

2004-11-08

Lab 4 and 5 Due

Stored Procedures, Triggers, and Views

 

12

Fri

2004-11-12

Test 2

 

Attendance is Mandatory for all students

13

Mon

2004-11-15

Lab 6 Due

Group Project Physical Model Due

User and Security Management

Chapter 9

13

Fri

2004-11-19

Chapter 9: Managing Multi-user Databases

 

14

Mon

2004-11-22

Chapter 9: Managing Multi-user Databases

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

Chapter 15

14

Fri

2004-11-26

Thanksgiving Holiday (Elements Lab will be closed)

 

15

Mon

2004-11-29

Group Presentation I

Attendance is Mandatory for all students

15

Fri

2004-12-03

Group Project Final Report due (Bound and electronic version) for all groups

Demo I starting at 9.05 am in the lab

Attendance is Mandatory for the group during their demo

 

 

 

 

 

 

 

Last Updated: 11/5/2004 11:30:33 AM