CS 442: Database Management Systems

Prof. Wendy Hui Wang 
MR 10:00 – 10:50AM Mclean 106, F 10:00-10:50AM Babbio 319
Office Hours: Mondays 3:30-4:30pm, Babbio 620. All other times by appointment.

TA: Vishakha Sharma
Office Hour: ??? 2:30-3:30pm, Burchard 127.


Prerequisites

CS 385 Data Structures and Algorithms II

Textbook

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

Aug 30

Introduction

Ch. 1

2

Sep 2

ER model (I)

Ch. 2

3

Sep 3

ER model (II)

Ch. 2

4

Sep 6

ER model tutorial

5

Sep 9

Relational model (I)

Ch. 3.1 - 3.4

6

Sep 10

Relational model (II)

Ch. 3.1-  3.4

7

Sep 13

Relational model Tutorial

8

Sep 16

ER to relational mapping (I)

Ch. 3.5

9

Sep 17

ER to relational mapping (II)

Ch. 3.5

10

Sep 20

Relational algebra (I)

Ch. 4.1 – 4.2

11

Sep 23

Relational algebra (II)

Ch 4.1 – 4.2

12

Sep 24

Relational algebra –Tutorial

Ch. 4.3

13

Sep 27

SQL - basic operators (I)

Ch. 5.1 – 5.3

14

Sep 30 

SQL – basic operators (II)

Ch. 5.1 – 5.3

15

Oct 1

SQL – Nested queries (I)

Ch. 5.4

16

Oct 4

SQL – Nested queries (II)

Ch. 5.4

17

Oct 7

SQL – aggregation and grouping (I)

Ch 5.5

18

Oct 8

SQL – aggregation and grouping (II)

Ch 5.5

19

Oct 12

SQL – Tutorial

20

Oct 14

Midterm overview

21

Oct 15

Midterm

22

Oct 18

Cancelled (switch with Oct 15’s project lecture)

23

Oct 21

Midterm post-review

24

Oct 22

Nulls, Joins, Constraints

Ch. 5.6 – 5.8

25

Oct 25

Triggers, Embedding, Cursors, JDBC (I)

Ch. 6.1 – 6.3

26

Oct 28

Triggers, Embedding, Cursors, JDBC (II)

Ch. 6.1 – 6.3

27

Oct 29

Lab session – SQL Programming (I)

28

Nov 1

Lab session – SQL Programming (II)

29

Nov 4

Functional dependencies (I)

Ch. 19.2 – 19.3

30

Nov 5

Functional dependencies (II)

Ch. 19.2 – 19.3

31

Nov 8

Functional dependencies (III)

Ch. 19.2 – 19.3

32

Nov 11

Schema normalization (I)

Ch. 19.4 – 19.6

33

Nov 12

Schema normalization (II)

Ch. 19.4 – 19.6

34

Nov 15

Schema refinement (I)

Ch. 19.7

35

Nov 18

Schema refinement (II)

Ch. 19.7

36

Nov 19

Schema refinement – Tutorial (I)

Ch. 19.7

37

Nov 22

Schema refinement – Tutorial (II)

Ch. 19.7

38

Nov 25, 26

Thanksgiving Recess.  No Classes.

 

39

Nov 29

XML (I)

Ch 27.6

40

Dec 2

XML (II)

Ch. 27.6

41

Dec 3

XML (I)

Ch. 27.6

42

Dec 6

Security issues in database management (I)

Ch. 21

43

Dec 9

Security issues in database management (II)

 

44

Dec 10

Final overview

 

45

???

Final exam