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 23 -- Hoffer: Ch. 1
- Slides from Lecture 1 download
Database planning and Conceptual Design -- Aug 28, Aug 30 -- Hoffer: Ch. 2 & 3 & 14
Organizing Information into a Database (logical database design) & Normalization --
Sep 4, 6 -- Hoffer: Ch. 4 & 5Relational DBMS & Relational Algebra and Calculus : Introduction to SQL -- Sep 11, 13 -- Hoffer: Ch. 7 & App. C
Assignment 1 due Thurs Sep 13th.
Database Design: Physical Design and Access Methods -- Sep 18, 20 -- Hoffer: Ch. 6 & App. C
Assignment 2 due Thursday 20th.
XML and SemiStructured Data -- Sep 25, 27 -- Hoffer: Ch. 7
- Special Guest Faculty - Erik Wilde (EMC Corp.)
- Slides from Lecture 10 and 11
XML Databases -- Oct 2, 4 -- Hoffer: Ch. 8
Slides from Lecture 12 download
Thursday - Special Guest Faculty - Jeroen van Rotterdam (EMC Corp.)
Database Applications & PHP -- Oct 9, 11 -- Hoffer: Ch. 10
Database Security and Integrity & Database Administration -- Oct 16, 18 -- Hoffer: Ch. 10
Object-Relational DBMS & JDBC -- Oct 23, 25 -- Hoffer: Ch. 12
Data Warehouses and Data Mining -- Oct 30, Nov 1 Hoffer: Ch. 9
Data and Text Mining Applications -- Nov 6, 8
Big Data and Databases -- Nov 13, 15
- Tuesday - Special Guest - Tom Lento of Facebook on Hive
Future of DBMS - Next Generation Applications -- Nov 20
- November 22 -- Thanksgiving Holiday
Wrapup : Class Project Demos -- Nov 27, 29
Class Project Demos -- Dec 4, 6
- RRR Period - no lectures
Final Project Papers Due -- Dec 10
- Dec 10 RRR Period ends - Final final project papers due.