ADB Assignment 3

Overview

You should have enough information now to begin implementing your database. In this exercise, you will illustrate the normalization process, develop schema for your database, and implement the tables using Oracle SQL.

The Normalization Process

Please include on your class page a progression from unnormalized through first, second, and third form normalization. Your tables can be described in any way you wish, but they need not yet be formal SQL tables for this part of the project.

Normalized Schema

Submit a formal schema for your database. This should be in third normal form, should include all anticipated tables and relationships, should indicate primary and foreign keys, and should describe all the major fields in the database. This is the most important document your group will produce all semester long. Get it right.

Implementation in SQL

Write a script in SQLPlus that will implement your database. Write enough code to create all tables, fill them in with a small amount of test data, and do a simple query testing the tables' integrity. Include the source code of this script and a sample run from SQLPlus.

Due date:

All work must be accessible from group main page by June 6, 2000

Have FUN!!!

© Andy Harris
Indiana University / Purdue University, Indianapolis
email: aharris@cs.iupui.edu
homepage: http://www.cs.iupui.edu/~aharris