Week 1
|
Chapter 1 - 2.2
|
Overview of DBMS and relational data model.
|
Week 2
|
Chapter 2.2 - 2.4
|
Relational algebra, basic SQL.
|
Week 3
|
Chapter 2.4 - 3.2
|
Labor day (Monday) Conference trip (Wednesday) Constraints, functional dependencies.
|
Week 4
|
Chapter 3.3
|
Anomalies, BCNF.
|
Week 5
|
Chapter 3.4
|
Decomposition.
|
Week 6
|
Chapter 3.4
|
Decomposition continued.
|
Week 7
|
Chapter 3.5
|
Review and
Test 1, 3NF. Homecoming (Friday)
|
Week 8
|
Chapter 3.6
|
Multivalued dependency, 4NF.
|
Week 9
|
Chapter 4.1-4.6
|
E/R Model, design principles, constraints
|
Week 10
|
Chapter 4.1-4.6
|
weak entity sets, E/R to Relational model.
|
Week 11
|
Chapter 6.1 - 6.3
|
review and Test 2, SQL.
|
Week 12
|
Chapter 6.4
|
SQL Veterans day (Friday)
|
Week 13
|
Chapter 6.5 - 6.6
|
SQL modifications, transactions.
|
Week 14
|
Chapter 7
|
Constraints and triggers, Bag model Thanksgiving (Wednesday + Friday)
|
Week 15
|
Chapter 5.1 - 5.3
|
Extended relational algebra, Datalog. Review and
Test 3
|
Week 16
|
Chapter 5.4
|
review & wrap up.
|