MIS 5612: Database Design and Administration

Course Syllabus

Assignments

Practice Exercise (Twin Cities Book Club)                                          -- Solutions

Project

Class Schedule

 

SESSION #

DATE

TOPIC

READING

WHAT’S DUE?

 

1a.

 

Aug. 25

The Entity-Relationship Model

(Additional Notes)

Chapter 3

(pp. 85-105)

 

1b.

The E-R Model (contd.)

(Additional Notes)

Chapter 3

(pp. 106-123)

 

 

2a.

 

Sept. 8

The Enhanced E-R Model

Chapter 4

(pp. 139-156)

Assignment 1 due

2b.

Lab 1 -- SQL: Introduction

Chapter 7

(pp. 289-306)

 

 

3a.

 

Sept. 15

The Enhanced E-R Model (contd.)

Chapter 4

(pp. 157-180)

Project: Part I due

3b.

Lab 2 -- SQL: Querying Single Tables

Chapter 7

(pp. 308-319)

 

 

4a.

 

Sept. 22

The Relational Model

Chapter 5

(pp. 187-204)

Assignment 2 due

4b.

Lab 3 -- SQL: Aggregation and Group Functions

Chapter 7

(pp. 320-326)

 

 

5a.

 

Sept. 29

The Relational Model (contd.)

 

Chapter 5

(pp. 205-210)

Project: Part II due

5b.

Lab 4 -- SQL: Joins and Sub-queries

Chapter 8

(pp. 333-348)

 

 

6a.

 

Oct. 6

Normalization

Chapter 5

(pp. 211-222)

Assignment 3 due

6b.

Lab 5 -- SQL: Advanced Queries

 

Chapter 8

(pp. 349-362)

 

 

7.

 

 Oct. 13

Final Exam

 

Project: Part III due