The textbook for this course is Elmasri, R. & Navathe, S. (2000). Fundamentals of Database Systems 3rd edition. Reading, MA: Addison-Wesley. Unless otherwise stated, the chapters listed in the schedule come from this book.

All other readings are on reserve in the SILS Information and Technology Resource Center on the first floor of Manning Hall, or are available on the Web. Readings are listed in the order in which they should be read. Other readings or assignments may be assigned as appropriate.

Table of Contents

Introduction. Tuesday, 1/8/02, Thursday, 1/10/02.

Ch. 1, 10.1.

Haderle, D. (1990). Database role in information systems: The evolution of database technology and its impact on enterprise information systems. Database Systems of the 90s. Berlin: Springer-Verlag, 1-14. [PAM]

Thursday, 1/10/02, assign Lab 1; due Thursday, 1/24/02.

Tuesday, 1/15/02, Access Workshop (optional). Meet in lab classroom.

Ch. 10.7, 10.8.

Database Concepts and Architecture. Thursday, 1/17/02.

Ch. 2.

Entity Relation Modeling.
Tuesday, 1/22/02, Thursday, 1/24/02, Tuesday, 1/29/02,
Thursday, 1/31/02, Tuesday, 2/5/02.

Moody, D. (1996) The seven habits of highly effective data modelers. Database Programming & Design, 9, 10, 57-64 (w/o ads). [PAM]

Ch. 3 & 4.

Thursday, 1/24/02, Lab 1 due.

Tuesday, 1/29/02, assign Lab 2; due Thursday, 2/28/02.

Thursday, 1/31/02, assign A1; due Tuesday, 2/12/02.

Relational Model.
Thursday, 2/7/02, Tuesday, 2/12/02, Thursday, 2/14/02,
Tuesday, 2/19/02, Thursday, 2/21/02.

Ch. 7, 9.1-9.2.

Tuesday, 2/12/02, A1 due.

Sample Answer for A1

Thursday, 2/14/02, assign A2; due Tuesday, 2/26/02.

Tuesday, 2/29/02, assign A1 Makeup Assignment, due no later than Thursday, 3/7/02.

Thursday, 2/21/02, assign A3; Due Thursday, 4/4/02.

Storage and Indexing. Tuesday, 2/26/02, Thursday, 2/28/02, Tuesday, 3/5/02.

Ch. 5.1, 5.6-5.9.1, 6.1-6.3.

Bowles, K. et al. (2001). Informatics application provides instant research to practice results. Proceedings of the 2001 American Medical Informatics Annual Symposium. [PAM]

Indexing Examples. These are the examples we'll be looking at in class.

Tuesday, 2/26/02, A2 due.

Thursday, 2/28/02, Lab 2 due.

Tuesday, 3/5/02, assign Lab 3; due Thursday, 3/28/02.

SQL. Thursday, 3/7/02, Tuesday, 3/19/02, Thursday, 3/21/02, Tuesday, 23/26/02, Thursday, 3/28/02.
Tuesday, 3/12/02 & Thursday, 3/14/02, Spring Break

Ch. 8

Harrington, J. (1998). SQL Clearly Explained (optional, for your further reference). [QA76.73.S67 H37 1998]

SQL DDL example.

DDL exercise.

Thursday, 3/7/02, A1 Makeup Assignment due.

Thursday, 3/28/02, L3 due.

Thursday, 3/28/02, assign Lab 4, due Tuesday, 4/23/02.

Query Processing. Tuesday, 4/2/02.

Ch 18.

Query Processing Trees. These are the examples we'll be looking at in class.

Normalization. Thursday, 4/4/02, Tuesday, 4/9/02, Thursday, 4/11/02, Tuesday, 4/16/02.

Kettelhut, M. (1991). User-friendly traps: Controlling problems in data base design. Information Systems Management, 8,4, 22-28. [PAM]

Ch. 14; omit proofs and algorithms, Ch 15.1 - 15.2.

Thursday, 4/4/02, A3 due.

Thursday, 4/11/02, assign A4; due Thursday 4/18/02.

Thursday, 4/11/02, assign A3 optional makeup; due no later than Tuesday, 4/23/02.

Reverse Engineering and Data Quality. Thursday, 4/18/02, Tuesday, 4/23/02, Thursday, 4/25/02.

Premerlani, W. & Blaha, M. (1994). An approach for reverse engineering of relational databases. Communications of the ACM, 37, 5, 42-49, 134. [http://www.acm.org/pubs/articles/journals/cacm/1994-37-5/p42-premerlani/p42-premerlani.pdf]

Orr, K. (1998). Data Quality and Systems Theory. Communications of the ACM,, 41, 2, 66-71. [http://www.acm.org/pubs/articles/journals/cacm/1998-41-2/p66-orr/p66-orr.pdf].

Redman, T. (1998). The Impact of Poor Data Quality on the Typical Enterprise. Communications of the ACM,41, 2, 79-82. [http://www.acm.org/pubs/articles/journals/cacm/1998-41-2/p79-redman/p79-redman.pdf]

Thursday, 4/18/02, A4 due.

Tuesday, 4/23/02, L4 due.

Tuesday, 4/23/02, A3 optional makeup due.

Wrap-up. Tuesday, 4/30/02.

Tuesday, 4/30/02, assign take-home final exam; due Thursday, 5/9/02, 4:00 p.m.