|
Day
|
Date
|
Subject
|
Pre-reading
|
Lecture Notes
|
|
M
|
8/27
|
Introduction to databases
|
Chapter 1
|
notes #1
|
|
W
|
8/29
|
Database applications examples
|
Sections 11.4.1-2
|
notes #2
|
|
F
|
8/31
|
Database environment
|
Chapter 2
|
notes #3
|
|
M
|
9/3
|
Labor Day (NO CLASS)
|
|
|
|
W
|
9/5
|
Database architectures and Web applications
|
Chapter 3
|
notes #4
|
|
F
|
9/7
|
Relational database model
|
Chapter 4
|
notes #5
|
|
M
|
9/10
|
Entity-relationship (ERD’s) modeling
|
Chapter 12
|
notes #6
|
|
W
|
9/12
|
ERD’s examples
|
Appendix C
|
|
|
F
|
9/14
|
Database system lifecycle
|
Chapter 10
|
notes #7
|
|
M
|
9/17
|
Rosh Hashanah (NO CLASS)
|
|
|
|
W
|
9/19
|
Conceptual data modeling
|
Chapter 16
|
notes #8
|
|
F
|
9/21
|
Conceptual data modeling examples
|
|
|
|
M
|
9/24
|
Normalization
|
Chapter 14
|
notes #9
|
|
W
|
9/26
|
Yom Kippur (NO CLASS)
|
|
|
|
F
|
9/28
|
Normalization examples
|
|
|
|
M
|
10/1
|
Logical data modeling
|
Chapter 17
|
notes #10
|
|
W
|
10/3
|
Logical data modeling examples
|
|
|
|
F
|
10/5
|
Physical database design
|
Chapter 18
|
notes #11
|
|
M
|
10/8
|
Physical database design examples
|
|
|
|
W
|
10/10
|
Example of database system design
|
Appendix A, B
|
|
|
F
|
10/12
|
Review
|
|
|
|
M
|
10/15
|
SQL queries
|
Chapter 6
|
notes #12
|
|
W
|
10/17
|
FIRST MIDTERM
|
|
|
|
F
|
10/19
|
SQL queries examples
|
|
sales database
|
|
M
|
10/22
|
SQL queries
|
|
|
|
W
|
10/24
|
SQL queries examples
|
|
|
|
F
|
10/26
|
SQL commands
|
Chapter 7
|
notes #13
|
|
M
|
10/29
|
SQL commands examples
|
|
|
|
W
|
10/31
|
Advanced SQL queries
|
|
notes #14
peer review form
|
|
F
|
11/2
|
Query By Example
|
Chapter 9
|
|
|
M
|
11/5
|
Database security
|
Chapter 20
|
notes #15
|
|
W
|
11/7
|
Transaction management
|
Chapter 22
|
notes #16
|
|
F
|
11/9
|
Review
|
|
|
|
M
|
11/12
|
SECOND MIDTERM
|
|
|
|
W
|
11/14
|
Professional, legal, and ethical concerns
|
Chapter 21
|
notes #17
|
|
F
|
11/16
|
Web database development
|
Chapter 30
|
notes #18
|
|
M
|
11/19
|
Web database development with PHP & MySQL - language
|
|
|
|
W
|
11/21
|
Thanksgiving (NO CLASS)
|
|
|
|
F
|
11/23
|
Thanksgiving (NO CLASS)
|
|
|
|
M
|
11/26
|
Web database development with PHP & MySQL - forms
|
|
|
|
W
|
11/28
|
Web database development with PHP & MySQL - queries
|
|
|
|
F
|
11/30
|
Distributed databases
|
Chapter 24
|
|
|
M
|
12/3
|
Data warehousing concepts
|
Chapter 32
|
notes #19
|
|
W
|
12/5
|
OLAP
|
Chapter 34
|
|
|
F
|
12/7
|
Advanced topics in databases: the future
|
|
notes #20
|
|
W
|
12/12
10:30am – 12:30pm
|
FINAL PROJECT PRESENTATIONS
|
|
|
