CS 494 Topics and Readings

Revised March 15, 2006

Relational Database Design and Implementation

Database Design
SQL

Interfacing Application Software to Databases

ODBC (Open Database Connectivity)
JBDC (Java Database Connectivity)

XML (Extensible Markup Language) Methods to Interoperate with Databases
Object/Relational Mapping (ORM)

We will cover the class topics in the order listed below. No dates are listed, since I don't know exactly how long each topic will take. But hopefully in each class it should be clear where we are and therefore what you should read next. In each topic, the main reading should give you enough background to understand the class discussion. You will also need to refer to the supplemental reading and/or reference materials listed for each topic to get the additional information needed to do each programming assignment.

Relational Database Design and Implementation

Database Design

Main reading:

Overview of Normalization (through third normal form only)

Supplemental reading:

Chris Fehily, SQL: Visual QuickStart Guide, Peachpit Press

Chapter 2 "The Relational Model"

Steve Litt's page on Normalization

SQL

Main reading:

PostgreSQL Tutorial Chapter 1; Chapter 2; Sections 3.1-3.3

Supplemental reading:

Chris Fehily, SQL: Visual QuickStart Guide

pages 15-16 (first ed) or 19-20 (second ed) on PostgreSQL
Chapter 3 "SQL Basics" pages 41-49 (first ed) or 45-55 (second ed)
Chapter 4 "Retrieving Data from a Table" pages 61-83 (first ed) or 69-91 (second ed)
Chapter 7 "Retrieving Data from Multiple Tables" pages 157-173 (first ed) or 175-191 (second ed)
Chapter 9 (first ed) or 10 (second ed) "Inserting, Updating, and Deleting Rows"
Chapter 10 (first ed) or 11 (second ed) "Creating, Dropping, and Altering Tables" pages 301-328 (first ed) or 353-381 (second ed)