WK
DATE | TOPICS | READING | PTS | ASSIGNMENT | DUE |
1
01/21 |
Introduction, Survey
Conceptual Data Modeling
Entities and Attributes
Relationships
ER Diagram Elements
ER Diagram Conventions
Tool Introduction |
Chapters 1, 2
Introduction
Lesson 1
Lesson 2 |
10
20
20
30 |
Survey
Quiz 1
Activity 1
Activity 2 |
In Class
Online 01/27
Email 01/30
Email 01/30 |
2
01/28 |
Entities/Attributes
DB Structure Basics
Relationships: M:M, Valid |
Chapter 3
Lesson 3
Lesson 4 |
40
30
40 |
Quiz 2
Activity 3
Project 1 |
Email 02/06
Email 02/06
Email 02/06 |
3
02/04 |
Constraints
UID, Data Types
Modeling Change |
Lesson 5
Lesson 6 |
20
40 |
Quiz 3
Project 2 |
Email 02/13
Email 02/20 |
4
02/11 |
ER Model Patterns
ER Model Mapping |
Lesson 7
Lesson 8 |
30
30
20 |
Activity 4
Activity 5
Quiz 4 |
Email 02/20
Email 02/20
Email 02/20 |
5
02/18 |
Subtype Model Mapping
Data Normalization |
Lesson 9
Lesson 10
Chapter 4 |
20
40
40
40 |
Quiz 5
Activity 6
Activity 7
Project 3 |
Online 02/24
Email 02/27
Email 02/27
Email 03/06 |
6
02/25 |
Denormalized Data
Final Project |
Chapter 6
Lesson 11 |
20
20
100 |
Quiz 6
Quiz 7
Final Project |
Email 03/06
Online 03/06
Email 03/06 |
7
03/04 |
Final Project Lab
Final Exam Review |
|
|
|
|
8
03/11 |
Final Exam |
|
200
10 |
Evaluation |
In Class
In Class |
