SESSION #

DATE

TOPIC

READING

(Hoffer et al.)
 

WHAT’S DUE?

1a.

Oct. 18

Introduction to Database Design and Management

Chapters 1 and 2

1b.

The Entity-Relationship Model
 

Chapter 3
(pp. 87-109)
 

2a.

Oct. 25

The E-R Model: A Review and an Extension
 

Chapter 3
(pp. 110-135)

2b.

Lab 1 -- Introduction to the SQL Server Environment
 

3a.

Nov. 1

The Relational Model

Chapter 5
(pp. 199-228)
 

Assignment 1 due

3b.

Lab 2 -- Basics of SQL

Chapter 7
(pp. 307-326)
 

4a.

Nov. 8

Chapter 5
(pp. 221-226)

Project: Part I due

4b.

Lab 3 -- SQL: Querying Single Tables

Chapter 7
(pp. 328-340)
 

5a.

Nov. 15

The Enhanced E-R Model

Chapter 4
(pp. 150-165)
 

Assignment 2 due

5b.

Lab 4 -- SQL: Aggregation and Group Functions

Chapter 7
(pp. 340-346)
 

6a.

Nov. 22

Review of Data Modeling

Chapters 3 - 5

Project: Part II due

6b.

Lab 5 -- SQL: Joins and Sub-queries

Chapter 8
(pp. 356-375)
 

7a.

Nov. 29

Normalization

Chapter 5
(pp. 226-238)
 

Assignment 3 due

(by Dec 2, Friday)

7b.

Lab 6 -- SQL: Advanced Queries

Chapter 8
(pp. 376-388)

8. 

Dec. 6

Final Exam

Project: Part III due