Tentative Lecture & Assignment Schedule - Spring 2006

Last updated: 2/13/06 21:38 PM

Project #6 due

Date

Lecture Topic

Notes

Readings*

 Assignments
T 1/9 Course Overview

lecture_1 [.ppt]

Chpt. 1

Get Oracle/Gradiance Accounts
R 1/11 Introduction to the Entity-Relationship Model (E/R) lecture_2 [.ppt] Sec. 2.1, 2.2  
T 1/16 The E/R Model Cont'd, Modeling of Constraints lecture_3 [.ppt] Sec. 2.3
R 1/18 Weak Entities / Intro to Relational Model lecture_4 [.ppt] Sec. 2.4, 2.5, 3.1 Finalize Project Teams
T 1/23 Introduction to the Relational Model lecture_5 [.ppt] Sec. 3.1 - 3.2  
R 1/25 From E/R to Relational lecture_6 [.ppt] Sec. 3.3 Homework #1 out; Project #1 out
T 1/30 Functional Dependencies lecture_7 [.ppt] Sec. 3.4, 3.5  
R 2/1 Functional Dependencies cont'd lecture_8 [.ppt] Sec. 3.5 Homework #1 due
T 2/6 Relational Design Theory lecture_9 [.ppt] Sec. 3.6.1 - 3.6.3 Project #1 due; Project #2 out
R 2/8 Boyce-Codd Normal Form lecture_10 [.ppt] Sec. 3.6.3 - 3.6.5 Homework #2 out
T 2/13 Third Normal Form, Multivalued Dependencies lecture_11 [.ppt] Sec. 3.6.6; Sec. 3.7.1-3.7.3  
R 2/15 Multivalued Dependencies Cont'd lecture_12 [.ppt] Sec. 3.7.1-3.7.3 Project #2 due
T 2/20 Relational Algebra; Intro to Oracle lecture_13 [.ppt] Sec. 5.1, 5.2 Project #3 out
R 2/22 Relational Algebra lecture_14 [.ppt] Sec. 5.2, 5.4 Homework #2 due
T 2/27 Relational Algebra lecture_15 [.ppt] Sec. 5.4, 5.5  
R 3/1 SQL: Introduction, Joins lecture_16 [.ppt] Sec. 6.1, 6.2 Project #4 out
T 3/6 Review Session Review  
R 3/8 Midterm
T 3/13 Break
R 3/15 Break
T 3/20 SQL Subqueries, Full Relation Ops lecture_17 [.ppt] Sec. 6.3, 6.4 Project #3 due
R 3/22 SQL Cont'd lecture_18 [.ppt] Homework #3 out
T 3/27 Indexing and DB Tuning lecture_19 [.ppt] Sec. 6.5, 6.6 Project #4 due; Project #5 out
R 3/29 SQL Views, Constraints Part I lecture_20 [.ppt] Sec. 6.7, 7.1; optional: SQL for Web Nerds: Views  
T 4/3 Constraints Part II lecture_21 [.ppt] Sec.7.2, 7.4; optional: SQL for Web Nerds: Triggers Homework #3 due
R 4/5 SQL in a Programming Environment lecture_22 [.ppt] Sec.8.1 Project #5 due; Project #6 out
T 4/10 SQL in a Programming Environment - Part II lecture_23 [.ppt] Sec.8.2, 8.5, 8.6
R 4/12 Security and User Authorization in SQL lecture_24 [.ppt] Sec. 8.7
T 4/17 Advanced Database Topics lecture_25/26 [.ppt1, .ppt2]  
R 4/19 Project Demos CSE 114 Project #6 due
T 4/24 Review Session Review  
F 5/4 Final Exam

* Readings should be completed before the lecture to which they correspond.

Unless otherwise stated, readings are from:

Database Systems - The Complete Book. First Edition, H. Garcia-Molina, J. D. Ullman, and J. Widom. Prentice Hall, Upper Saddle River, NJ, 2002. ISBN: 0-13-031995-3.