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

2005-01-21

Introduction/Overview/Syllabus/Course Expectations

Class Web site

1

Fri

2005-01-21

Deadline: Last day of the official add/drop period; after this date, changes in registration require the approval of the department chair and usually the student's dean.

 

2

Mon

2005-01-24

Chapter 1: Introduction to Database Processing

Chapter 1

2

Fri

2005-01-28

Chapter 1: Introduction to Database Processing

Chapter 2: ER Data Modeling: Tools and Techniques

Chapter 2

3

Mon

2005-01-31

Chapter 2: ER Data Modeling: Tools and Techniques

Lab 1 Due

 

3

Wed

2005-02-02

Deadline: Last Day to Drop a class with possible refund.

 

3

Fri

2005-02-04

Chapter 3: ER Data Modeling: Process and Examples

Chapter 3

4

Mon

2005-02-07

Chapter 3: ER Data Modeling: Process and Examples

Chapter 3

4

Fri

2005-02-11

Chapter 4: The Relational Model and Normalization

Chapter 4

5

Mon

2005-02-14

Chapter 4: The Relational Model and Normalization

Lab 2 Due

 

5

Mon

2005-02-14

Deadline: Last Day to Drop a class without possible academic penalty. No Refund.

 

5

Fri

2005-02-18

Chapter 5: Database Design

Chapter 5

6

Mon

2005-02-21

Chapter 5: Database Design

 

6

Fri

2005-02-25

Chapter 6: SQL

Lab 3 Due

Group Project Topic/Team Due

Chapter 6

7

Mon

2005-02-28

Chapter 6: SQL

 

7

Fri

2005-03-04

Test 1

Group Project Proposal Due

Attendance is Mandatory for all students

8

Mon

2005-03-07

Chapter 6: SQL

 

 

8

Fri

2005-03-11

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

Group Meeting in PAI 5.44

Attendance is Mandatory for all students

 

Mon-Sat

2005-03-14 – 2005-03-19

Spring Break Holiday (Elements Lab will be closed)

 

9

Mon

2005-03-21

Chapter 6: SQL

 

9

Fri

2005-03-25

Chapter 6: SQL

Group Project Logical Model Due

 

10

Mon

2005-03-28

Stored Procedures

 

10

Mon

2005-03-28

Deadline: Last day an undergraduate student may, with the dean's approval, withdraw from the University or drop a course except for urgent and substantiated, nonacademic reasons.

 

10

Fri

2005-04-01

Chapter 7: SQL in Applications

Lab 4 Due

Chapter 7

11

Mon

2005-04-04

Triggers and Views

 

11

Fri

2005-04-08

Lab 5 Due

User and Security Management

 

12

Mon

2005-04-11

Test2

Attendance is Mandatory for all students

12

Fri

2005-04-15

Chapter 9: Managing Multi-user Databases

Chapter 9

13

Mon

2005-04-18

Chapter 9: Managing Multi-user Databases

Group Project DDL Due

 

13

Fri

2005-04-22

Chapter 15: Sharing Enterprise Data

Group Project PowerPoint presentation Due by email by for all groups by 5 pm

 Group Project Intra-Team Grades Due by email for all students by 5pm

Chapter 15

14

Mon

2005-04-25

Group Presentation I

 

Attendance is Mandatory for all students

14

Fri

2005-04-29

Group Presentation II

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

Demo I + II

Attendance is Mandatory for all students

 

 

 

 

 

 

 

Last Updated: 2/23/2005 8:50:41 AM