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 i.e. at 8.30 am CST. 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 outlined in the home page.

 

Week

Day

Date

Topic

Reading Assignments

Due before the class

1

Mon

2002-01-14

Introduction/Overview/Syllabus

 

1

Thu

2002-01-17

Last day of the official add/drop period; after this date, changes in registration require the approval of the chairman and usually the student's dean. (See General Information, chapter 4, for required approvals.) Last day undergraduate students may register without the approval of the registrar. Last day graduate students may register and pay fees without the approval of the graduate dean.

 

1

Fri

2002-01-18

Chapter 1: File Systems and Databases

Chapter 1

2

Mon

2002-01-21

Martin Luther King Jr. Day holiday

Elements Lab closed

 

2

Fri

2002-01-25

Chapter 2: The Relational Database Model

Chapter 2

3

Mon

2002-01-28

Chapter 2: The Relational Database Model

 

3

Wed

2002-01-30

Twelfth class day; this is the date the official enrollment count is taken. Last day an undergraduate student may add a course except for rare and extenuating circumstances. Payment for added courses (add bill) due. Last day to drop a course for a possible refund. (See General Information, chapter 4, for required approvals.)

 

3

Fri

2002-02-01

Chapter 3: Entity Relationship (E-R) Modeling

Chapter 3

4

Mon

2002-02-04

Chapter 4: Normalization of Database Tables

Chapter 4

4

Thu

2002-02-07

Lab 1 Assigned

 

4

Fri

2002-02-08

Chapter 5: SQL

Chapter 5

5

Mon

2002-02-11

Chapter 5: SQL

Lab 2 Assigned

 

5

Mon

2002-02-11

Last day to drop a course without a possible academic penalty. (See General Information, chapter 4, for required approvals.)

 

5

Fri

2002-02-15

Chapter 5: SQL

Lab 1 Due

 

6

Mon

2002-02-18

Test 1

All materials in course upto Test 1 from the beginning of the course

6

Fri

2002-02-22

SQL Server Connectivity through Java

Group Project Topic/Team Due

Lab 2 Due

 

7

Mon

2002-02-25

Stored Procedures, Triggers, and Views

Group Project Discussions

 

7

Fri

2002-03-01

Stored Procedures, Triggers, and Views

Group Project Proposal Due

 

8

Mon

2002-03-04

SQL Server Import facility

Lab 3 assigned

 

8

Fri

2002-03-08

SQL Server User Security

Group Project Logical Model Due (midnight)

 

9

Mon

2002-03-11

Spring Break

Elements Lab closed during this whole week.

 

9

Fri

2002-03-15

Spring Break

Elements Lab closed during this whole week.

 

10

Mon

2002-03-18

Chapter 13: The Data Warehouse

Chapter 13

10

Fri

2002-03-22

Chapter 13: The Data Warehouse

 

11

Mon

2002-03-25

Test 2

All materials in course upto Test 2 from the beginning of the course

11

Mon

2002-03-25

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. Last day a student may change registration in a course to or from the pass/fail or credit/no credit basis. Last day to apply for an undergraduate degree.

Last day an undergraduate student or a law student may register in absentia.

 

11

Wed

2002-03-27

Lab 3 Due

 

11

Fri

2002-03-29

Chapter 6: Database Design

Chapter 6

12

Mon

2002-04-01

Chapter 6: Database Design

Group Project DDL Due

 

12

Tue

2002-04-02

Lab 4 and 5 assigned

 

12

Fri

2002-04-05

Chapter 7: The University Lab: Conceptual Design

Chapter 7

13

Mon

2002-04-08

Chapter 8: The University Lab: Conceptual Design Verification, Logical Design, and Implementation

Chapter 8

13

Fri

2002-04-12

Chapter 8: The University Lab: Conceptual Design Verification, Logical Design, and Implementation

 

14

Mon

2002-04-15

Chapter 9

Chapter 9

14

Tue

2002-04-16

Lab 4 and 5 due

 

14

Fri

2002-04-19

Backup Day/ New Database Technologies-XML/Project Review, Q&A

Group Project PowerPoint presentation Due by email by 5.00pm

Group Project Intra-Team Grades Due by email by 5.00pm

Attendance is required

15

Mon

2002-04-22

Group Project Presentation I (15 min. each group)

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

Attendance is required

15

Fri

2002-04-26

Group Project Presentation II

Demo I (15 min. each group) (10.15 am – 11.30 am in PAI 5.38)

Attendance is required

16

Mon

2002-04-29

Group Project Presentation III

Attendance is required

16

Fri

2002-05-03

Demo II (8.45 am – 11.30 am in PAI 5.38)

Attendance is required

 

Consult the registrar’s office for other relevant dates.

 

Home Page

 

Last Updated: 4/9/2002 8:42:21 AM