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 26 -- Hoffer: Ch. 1
- Slides from Lecture 1 download
Database planning and Conceptual Design -- Aug 31, Sep 2 -- Hoffer: Ch. 2 & 3 & 14
Organizing Information into a Database (logical database design) & Normalization --
Sep 7, 9 -- Hoffer: Ch. 4 & 5Assignment 1 due Thursday 9th.
Relational DBMS & Relational Algebra and Calculus : Introduction to SQL -- Sep 14, 16 -- Hoffer: Ch. 7 & App. C
MySQL -- Sep 21, 23 -- Hoffer: Ch. 7
- Tuesday: Kevin Heard on Using MySQL
- Thursday: No Class - workshop
Database Design: Physical Design and Access Methods -- Sep 28, 30 -- Hoffer: Ch. 6 & App. C
Assignment 2 due Tuesday 28th.
More on MySQL & Database Applications & PHP -- Oct 5, 7 -- Hoffer: Ch. 8
Database Security and Integrity & Database Administration -- Oct 12, 14 -- Hoffer: Ch. 10
Object-Relational DBMS & JDBC -- Oct 19, 21 -- Hoffer: Ch. 12
Data Warehouses and Data Mining -- Oct 26, Oct 28 Hoffer: Ch. 9
Data and Text Mining Applications -- Nov 2, 4
-
Slides from Lecture 18 download
Additional Slides (password protected) -
Slides from Lecture 19 download
Additional Slides (password protected)
-
Slides from Lecture 18 download
XML and Databases -- Nov 9, 11 -- Hoffer: Ch: 11
-
Slides from Lecture 20 download
Additional Slides (password protected) - No Class Thursday, Nov. 11 (Veterans Day)
-
Slides from Lecture 20 download
XML, The Grid/Cloud and Next Generation Applications -- Nov 16, 18 -- Hoffer: Ch. 13 & 15 & Appendix D.
-
Slides from Lecture 21 download
Additional Slides (password protected) - Slides from Lecture 22 download
-
Slides from Lecture 21 download
Future of DBMS -- Nov 23
- Slides from Lecture 23 download
- November 25&26 -- Thanksgiving Holiday
Wrapup : Class Project Demos -- Nov 30, Dec 2
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.