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 25 -- Hoffer: Ch. 1
- Slides from Lecture 1 download
Database planning and Conceptual Design -- Aug 30, Sep 1 -- Hoffer: Ch. 2 & 3 & 14
Organizing Information into a Database (logical database design) & Normalization --
Sep 6, 8 -- Hoffer: Ch. 4 & 5Relational DBMS & Relational Algebra and Calculus : Introduction to SQL -- Sep 13, 15 -- Hoffer: Ch. 7 & App. C
Assignment 1 due Tuesday Sep 13th.
Database Design: Physical Design and Access Methods -- Sep 20, 22 -- Hoffer: Ch. 6 & App. C
Assignment 2 due Thursday 22nd.
TBA -- Sep 27, 29 -- Hoffer: Ch. 7
More on MySQL & Database Applications & PHP -- Oct 4, 6 -- Hoffer: Ch. 8
TBA -- Oct 11, 13 -- Hoffer: Ch. 10
Database Security and Integrity & Database Administration -- Oct 18, 20 -- Hoffer: Ch. 10
Object-Relational DBMS & JDBC -- Oct 25, 27 -- Hoffer: Ch. 12
Data Warehouses and Data Mining -- Nov 1, 3 Hoffer: Ch. 9
Data and Text Mining Applications -- Nov 8, 10
- Slides from Lecture 18 download extra slides
- Slides from Lecture 19 download extra slides
XML and Databases -- Nov 13, 15 -- Hoffer: Ch: 11
- Slides from Lecture 20 download
Future of DBMS - Next Generation Applications -- Nov 22
- Slides from Lecture 21 download
- November 24&25 -- Thanksgiving Holiday
Wrapup : Class Project Demos -- Nov 29, Dec 1
RRR Week -- Dec 7, 9
- RRR Period - no lectures
Final Project Papers Due -- Dec 13
- Dec 13 RRR Period ends - Final final project papers due.