|
|
| Week | Topics | Reading | Assignment | Project| 1 (01/09, 01/11) |
Introduction
| Chapter 1 | Chapter 4
|
| 2 (01/16, 01/18)
|
-- Introduction | -- ER Model Chapter 4
|
|
| 3 (01/23, 01/25)
|
-- ER Model | -- Project Overview Chapter 2
|
|
| 4 (01/30, 02/01)
|
Relational Model
| Chapter 2
|
Assignment 1 | Stage 1 due
| 5 (02/06, 02/08)
|
--Relational Model | -- Relational Algebra Chapter 5
|
|
| 6 (02/13, 02/15)
|
Relational Algebra | Chapter 3
| Assignment 1 | due Tuesday
| 7 (02/20, 02/22) |
Relational Design
| Chapter 6
| Assignment 2
| Stage 2 due | Thursday 8 (02/27, 02/29)
|
Relational Design | Chapter 6
| Assignment 2 | due Thursday
| 9 (03/05, 03/07)
|
-- Midterm exam (Tuesday 3/5) | -- Relational Design Chapter 6
|
|
| 10 ( | Spring Break No Class
|
|
|
| 11 (03/19, 03/21) |
SQL-basics
| Chapter 9
|
| Stage 3 due | Thursday 12 (03/26, 03/28)
|
SQL-basics | Chapter 9
|
Assignment 3
|
SQL Code
| 13 (04/02, 04/04)
|
-- SQL-modifications and views | -- Indexing Chapter 14
|
|
| 14 (04/09, 04/11)
|
Indexing
| Chapter 17
|
Assignment 3 due |
| 15 (04/16, 04/18)
|
Crash Recovery
| Chapter 17
|
Assignment 4
|
| 16 (04/23, 04/25)
|
-- Crash Recovery | -- Final Review Chapter 17
| Assignment 4 due | Thursday Stage 4 | (04/22, 04/23, Full days) Report due Wedensday 17
|
Final Exam | (Tuesday 04/30, 7:30am-9:30am)
|
|
| |
|---|