CS 442: Database Management Systems

Prof. Wendy Hui Wang 
Tuesdays, 5-6:15pm, Babbio 319.

Thursdays, 5-6:15pm, Babbio 310.
Office Hours: Thursdays 3:30-4:30pm, Babbio 620. All other times by appointment.

TA: Mary Meladath(<mmeladat@stevens.edu>)
Office Hour: Thursdays 2:30-3:30pm, Burchard 127.


Prerequisites

Textbook

Required

Ramakrishnan and Gehrke. "Database Management Systems", 3rd Edition, McGraw-Hill, 2003. ISBN-10: 0072465638


Grading Policy

Assignment Breakdown

Submission Policy

All assignments are due at the end of class on the due date. Assignments are to be submitted via WebCT.

Late Policy

10 points (out of 100) will be taken off for each day that an assignment is turned in late. In other words, 10 points will be taken off if the assignment is turned in before midnight the day after the due date, and so on. Assignments may be turned in late up to 5 days after the due date/time.


Syllabus

Warning: The following is a tentative schedule and is subject to change.

 

Lecture

Date

Topic

Assignment

1

Sep 1

Introduction

Ch. 1

2

Sep 3

ER model I

Ch. 2

3

Sep 8

ER model Tutorial

Ch. 2

4

Sep 10

Relational model I

Ch. 3.1 - 3.4

5

Sep 15

Relational model Tutorial

Ch. 3.5

6

Sep 17

ER to relational mapping

Ch. 3.5

7

Sep 22

Relational algebra I

Ch. 4.1 – 4.2

8

Sep 24

Relational algebra –Tutorial

Ch. 4.3

9

Sep 29

SQL - basic operators

Ch. 5.1 – 5.3

10

Oct 1

SQL – Nested queries

Ch. 5.4

11

Oct 6

SQL – aggregation and grouping

Ch. 5.5

12

Oct 8

SQL – Tutorial

13

Oct 13

No Class - Monday Class Schedule

14

Oct 15 

Nulls, Joins, Constraints

Ch. 5.6 – 5.8

15

Oct 20

Triggers, Embedding, Cursors, JDBC

Ch. 6.1 – 6.3

16

Oct 22

Midterm overview

17

Oct 27

Midterm

18

Oct 29

Midterm post-review

19

Nov 3

Lab session – SQL Programming

20

Nov 5

Mid-term project presentation (I)

21

Nov 10

Mid-term project presentation (II)

22

Nov 12

Functional dependencies

Ch. 19.2 – 19.3

23

Nov 17

Schema normalization

Ch. 19.4 – 19.6

24

Nov 19

Schema refinement

Ch. 19.7

25

Nov 24

Schema refinement - Tutorial

Ch. 19.7

26

Nov 26

NO CLASS (Thanksgiving holiday)

27

Dec 1

XML (I)

Ch. 27.6

28

Dec 3

XML (II)

Ch. 27.6

29

Dec 8

Security issues in database management

Ch. 21

30

Dec 10

Final overview

31

Dec 14

Final Exam (1pm-4pm, BC122)