WK
DATE | TOPICS | READING | PTS | ASSIGNMENT | DUE |
1
09/09 |
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 09/15
Email 09/18
Email 09/18 |
2
09/16 |
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 09/25
Email 09/25
Email 09/25 |
3
09/23 |
Constraints
UID, Data Types
Modeling Change |
Lesson 5
Lesson 6 |
20
40 |
Quiz 3
Project 2 |
Email 10/02
Email 10/09 |
4
09/30 |
ER Model Patterns
ER Model Mapping |
Lesson 7
Lesson 8 |
30
30
20 |
Activity 4
Activity 5
Quiz 4 |
Email 10/09
Email 10/09
Email 10/09 |
5
10/07 |
Subtype Model Mapping
Data Normalization |
Lesson 9
Lesson 10
Chapter 4 |
20
40
40
40 |
Quiz 5
Activity 6
Activity 7
Project 3 |
Online 10/13
Email 10/16
Email 10/16
Email 10/23 |
6
10/14 |
Denormalized Data
Final Project |
Chapter 6
Lesson 11 |
20
20
100 |
Quiz 6
Quiz 7
Final Project |
Email 10/23
Online 10/23
Email 10/23 |
7
10/21 |
Final Project Lab
Final Exam Review |
|
|
|
|
8
10/28 |
Final Exam |
|
200
10 |
Evaluation |
In Class
In Class |
