DESC 382: Database Management
Schedule

Date
Non-class days
in italics

Topics

Readings

Due dates

January 5

Introduction and overview

Chapter 1

January 12

Data models

Chapter 2

January 16

Last day to add classes

January 19

The relational data model

Chapter 3

January 26

Entity Relationship (ER) modeling

Chapter 4

• Group memberships due

February 2

Normalization of database tables

Chapter 6

• Homework 1 due

February 9

Database design

Chapter 9

February 16

Midterm exam

Chapters 1, 2, 3, 4, 6 and 9

February 23

Winter break – no class

March 2

Introduction to SQL

Chapter 7

March 5

Last day to drop classes

March 9

Advanced SQL

Chapter 8

March 16

Advanced data modeling

Chapter 5

March 23

Business intelligence and data warehousing

Chapter 13

• Homework 2 due
• Wikipedia presentation: Distributed DBMS

March 30

Database connectivity and Web technologies

Chapter 14

• Wikipedia presentation: Transactions and concurrency

April 6

Database administration and security

Chapter 15

• Term project due
• Wikipedia presentation: Performance and optimization

TBD

Final exam

Chapters 5, 7, 8, 13, 14 and 15