Outline and Schedule
This is a preliminary outline for the course. It is expected to change during the semester.
(Week. Content -- dates -- readings)
Introduction to database concepts & Data Models -- Aug 28 -- Hoffer: Ch. 1
- Slides from Lecture 1 download
Database planning and Conceptual Design -- Sep 2, 7 -- Hoffer: Ch. 2 & 3 & 14
- Slides from Lecture 2 download
- Slides from Lecture 3 download
- Access Tutorial to help with Assignment 1.
- Diveshop Database for use in Assignment 1.
Organizing Information into a Database (logical database design) & Normalization --
Sep 9, 11 -- Hoffer: Ch. 4 & 5- Slides from Lecture 4 download
- Slides from Lecture 5 download
- Assignment 1 due at the beginning of the class on Thursday.
Database Design Workshop -- Sep 16, 18 -- Hoffer: Ch. 4 & 5
- Workshop Leaders: Shanna Epstein and Jonathan Hicks
- Slides for Tuesday download
- Ray will be gone this week.
Database Design: Physical Design and Access Methods -- Sep 23, 25 -- Hoffer: Ch. 6 & App. C
- Slides from Lecture 6 download
- Slides from Lecture 7 download
- Assignment 2 due at the beginning of the class on Thursday.
Relational DBMS & Relational Algebra and Calculus : Introduction to SQL -- Sept 30, Oct 2 -- Hoffer: Ch. 7
Introduction to MySQL & Database Applications -- Oct 7, 9 -- Hoffer: Ch. 8
Database Applications: Coldfusion and PHP & More on SQL & MySQL -- Oct 16 -- Hoffer: Ch. 10
- No Class Tuesday
- Link to coldfusion diveshop examples
- PHP files (compressed archive) download
- Slides from Lecture 12 download
Database Security and Integrity & Database Administration -- Oct 21, 23 -- Hoffer: Ch. 12
Object-Relational DBMS -- Oct 28, Oct 30 Hoffer: Ch. 9
- Slides from Lecture 15 download
- October 30 -- TBA
JDBC for Java Applications & Data Warehouses -- Nov 4, 6
- Slides from Lecture 16 download
- Slides from Lecture 17 download
- JDBC Java example (Java file)
Data Warehousing and Data Mining -- Nov 11, 13 -- Hoffer: Ch: 11
- Veteran's Day Holiday, Nov. 11th.
- Slides from Lecture 18 download
Data and Text Mining Applications -- Nov 18, 20 -- Hoffer: Ch. 13 & 15 & Appendix D.
Future of DBMS -- Nov 25, 27
- Slides from Lecture 21 download
- Nov 27-28 - Thanksgiving Holiday
Wrapup : Class Project Demos -- Dec 2, 5
- Dec 2 Presentations: Shanna, Abe & Srikanth, David
- Dec 4 Presentations: Jon, Ankit, Noah, Brian, Nanheng, Jesse
Wrapup : Class Project Demos -- Dec 9
- Dec 9 Presentations: Piyapat, Alana, Kathleen, Abhinav, Joyce, Joon, Mohammed