Exercises

• Employee Database Exercises (doc)
• Relational Algebra Answer Key (pdf)
• Predicate Calculus Answer Key (pdf)
• SQL Answer Key (pdf)
• University Database - ER Diagram, Schemas, Sample Data, and Exercises (ppt) (pdf)

Course Slides

• Introduction to Database Systems (pdf)
• Entity-Relationship Modelling (pdf)
• The Relational Model (pdf)
• Tuple and Domain Calculus (pdf)
• SQL - Data Definition Language (DDL) (pdf)
• SQL - Data Manipulation Language (DML) (pdf)
• Advanced SQL (pdf)
• Relational Database Design (pdf)
• Some additional slides on normalization (pdf)

Course Project

• DBMS Install (doc)
• Part 1 - DDL
• Part 2 - Data Generate
• Part 3 - Data Load
• Part 4 - Query Code & Execution
• Education Enterprise Database Schema Description
• Data Generating Program for the Education Enterprise Database

Course Project (past semesters)

• DBMS Install (doc)
• Course project - part #1 (doc)
• Course project - part #2 (doc)
• Course project - part #3 (doc)
• The TPC-H specification
• The 18MB data set for the course project (textfile)
• The 1GB data set for the course project (windows zip) (unix/linux zip)
• The 5GB data set for the course project (windows zip)

Historical Links

• E.F. Codd's paper "A Relational Model of Data for Large Shared Data Banks"
• D.D. Chamberlin's paper "A History and Evaluation of System R"
• The System R Website
• Wikipedia page on SQL
• A decent summary SQL standardization

Miscellaneous Links

• The book website
• The Transaction Processing Performance Council (TPC)
• An SQL Tutorial
• Sybase System Tables Diagram
• Free Graphical Database Training Tool
• Reviews on the Latest Storage Devices
• The Schema and Data for the Banking Database
• Some additional slides on modelling (pdf)