CISC437 - Database
Systems
Spring 2008
Instructor: Michael Haggerty
 UD Home Page CIS Home Page My Home Page |
| Quick Links | |
|---|---|
| Syllabus | Projects |
| MyCourses (aka WebCT): Login | Class Example Programs |
| Other Helpful Links: Using mySQL (Updates and clarifications welcome!) mySQL Limitations (Updates and clarifications welcome!) MySQL 5.0 Reference Manual Database Concepts Website (includes PPT Slides) Database Normalization Tips Important Dates: 02/25/2008 - Last day of Free Drop/Add 04/21/2008 - Last day to withdraw without academic penalty 05/27/2008 - CISC437 Database Systems Final 7-9PM in Purnell 233B 05/30/2008 - Last Day of Finals! |
| Class Number | Date | Topics | Relevant Reading* | Homework Due |
|---|---|---|---|---|
| 1 | 2/12 | Course Introduction Relational Algebra |
Chap 1 & 2 | |
| 2 | 2/19 | Relational Algebra SQL |
Chap 2, 3(to 3.10) | |
| 3 | 2/26 | More SQL | Chap 3, 4, 6(time Permitting) | Assignment 1 (relational algebra) |
| 4 | 3/4 | Database Design and the E-R Model, Database Normalization | Chap 6, 7 | Assignment 2 (SQL) |
| 5 | 3/11 | Database Normalization, Triggers, SQL Security | Chap 7, 8 | |
| 6 | 3/18 | SQL Security, XML, Review | Chap 8, 10 | Assignment 3 (Normalization) |
| 7 | 3/25 | Midterm | ||
| 8 | 4/1 | Spring Break (no Class) | ||
| 9 | 4/8 | Disk Storage Indexing (B+ Trees) |
Chap 11, 12 | Project Part 1 |
| 10 | 4/15 | Query Processing | Chap 13 | Assignment 4 (B+ Trees) |
| 11 | 4/22 | Query Optimization | Chap 14 | Project Part 2 |
| 12 | 4/29 | Transactions Concurrency Control mySQL C API |
Chap 14, 15 and Class Examples | Assignment 5 |
| 13 | 5/6 | Transactions, Recovery Systems | Chapter 16, 17 | Assignment 6 |
| 14 | 5/13 | Class Cancelled | ||
| 15 | 5/20 | Distributed Databases, Review | Project 3 Due |
Note: The date and time for the Final Exam will be held sometime during finals week. The university sets the times for final exams. These exam times will be announced later in the semester (typically mid-March.)
Do not make any plans that require you to leave campus before the end of finals week, until you know all the dates and times of your final exams.
© Michael Haggerty
haggerty@cis.udel.edu
CIS Department Instructor
Last Updated: