Syllabus and Schedule

Lecture

Day

Topic Covered

Assignments/Exams

1

Jan 09

Ch1&2

Introduction

1

2

Jan 11

1

3

Jan 16

Ch3

The ER Model

1

4

Jan 18

1

5

Jan 23

1

6

Jan 25

 Ch5&7 The Relational Model

1

7

Jan 30

 1

8

Feb 01

 Ch6 The Relational Algebra and Relational Calculus

Assignment 1 Due

9

Feb 06

1

10

Feb 08

1

11

Feb 13

 Ch8&9 SQL

1

12

Feb 15

1

13

Feb 20

Oracle9i Ch2&5

Oracle SQL & JDBC

Assignment 2 Due

14

Feb 22

 Exam1

1

15

Feb 27

 Ch10&11 Functional Dependencies and Normalization

1

16

Mar 01

1

1

Mar 06

Spring Break

1

1

Mar 08

1

17

Mar 13

 Ch10&11 Functional Dependencies and Normalization

Project Due

18

Mar 15

        1 page abstract of the term paper Due / Project Due

19

Mar 20

 Ch13 Storage

Assignment 3 Due

20

Mar 22

1

21

Mar 27

 Ch14 Indexing

1

22

 Mar 29 1

23

Apr 03

Assignment 4 Due 

24

 Apr 05 Exam2 1

25

Apr 10

 Ch17&18 Transaction Management & Concurrency Control

1

26

Apr 12

1

27

Apr 17

 Ch27 Data Mining

1

28

Apr 19

Ch28

 Data Warehousing and OLAP

1

29

Apr 24

 Presentation1 (Anil, Xianfeng, Christa)

1

30

Apr 26

 Presentation2 (Chaitanya, Bassam, Peter)

Assignment 5 & Term Paper Due

1

May 01

Exam3

1

NOTE:
This syllabus represents a general plan and it is subject to change.