|
Day
|
Date
|
Subject
|
Pre-reading
|
Assignment Due
|
|
M
|
8/27
|
Introduction to databases
|
Chapter 1
|
|
|
W
|
8/29
|
Database applications examples
|
Sections 11.4.1-2
|
|
|
F
|
8/31
|
Database environment
|
Chapter 2
|
|
|
M
|
9/3
|
Labor Day (NO CLASS)
|
|
|
|
W
|
9/5
|
Database architectures and Web applications
|
Chapter 3
|
|
|
F
|
9/7
|
Relational database model
|
Chapter 4
|
project proposal
|
|
M
|
9/10
|
Entity-relationship (ERD’s) modeling
|
Chapter 12
|
|
|
W
|
9/12
|
ERD’s examples
|
Appendix C
|
|
|
F
|
9/14
|
Database system lifecycle
|
Chapter 10
|
|
|
M
|
9/17
|
Rosh Hashanah (NO CLASS)
|
|
assignment #1
|
|
W
|
9/19
|
Conceptual data modeling
|
Chapter 16
|
|
|
F
|
9/21
|
Conceptual data modeling examples
|
|
|
|
M
|
9/24
|
Normalization
|
Chapter 14
|
|
|
W
|
9/26
|
Yom Kippur (NO CLASS)
|
|
|
|
F
|
9/28
|
Normalization examples
|
|
project conceptual model
|
|
M
|
10/1
|
Logical data modeling
|
Chapter 17
|
|
|
W
|
10/3
|
Logical data modeling examples
|
|
|
|
F
|
10/5
|
Physical database design
|
Chapter 18
|
|
|
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
|
|
|
W
|
10/17
|
FIRST MIDTERM
|
|
|
|
F
|
10/19
|
SQL queries examples
|
|
assignment #2
|
|
M
|
10/22
|
SQL queries examples
|
|
|
|
W
|
10/24
|
SQL queries examples
|
|
project logical model
|
|
F
|
10/26
|
SQL commands
|
Chapter 7
|
|
|
M
|
10/29
|
SQL commands examples
|
|
|
|
W
|
10/31
|
Advanced SQL queries
|
|
|
|
F
|
11/2
|
Query-By-Example
|
Chapter 9
|
|
|
M
|
11/5
|
Database security
|
Chapter 20
|
|
|
W
|
11/7
|
Transaction management
|
Chapter 22
|
assignment #3
|
|
F
|
11/9
|
Review
|
|
|
|
M
|
11/12
|
SECOND MIDTERM
|
|
|
|
W
|
11/14
|
Professional, legal, and ethical concerns
|
Chapter 21
|
|
|
F
|
11/16
|
Web database development
|
Chapter 30
|
|
|
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
|
assignment #4
dreamhome database
|
|
W
|
12/5
|
OLAP
|
Chapter 34
|
|
|
F
|
12/7
|
Advanced topics in databases: the future
|
|
|
|
W
|
12/12
10:30am – 12:30pm
|
FINAL PROJECT PRESENTATIONS in SNYGG 106
|
|
oral presentation
project final report
final report checklist
peer review form
|
