CS 450 Database Assignment #3

.You are to hand in a simple Oracle Database System including the following features

A 5+ Table Database

A 4NF design showing the all the DB attributes and FDs and MVDs

A Design of the ERD and DFD for your system

A Report describing your system the enterprise it is modeling

A client front-end using Java JDBC which implements behavior in your DFD design

Your Database will include the following:

At least 2 Triggers

At least 2 Stored Functions

At least 2 Stored Procedures

At least 2 Detailed Reports

At least 5 Tables with at least 4 foreign keys

The project is due on December 19, 2001. It should be handed in with all source codes, design work, and the written paper.

The presentation should be 10 minutes, and should get right to the point of your Database System.

You should prepare a Powerpoint presentation consisting of 5-10 pages which best illustrate your presentation. Slides can include graphics or text, as well as possible screenshots of your system. Text slides should have a few bulleted highlights, and not have copies of paragraphs from your paper. All group members must present and the grades of the presentation will factor into the final project grade.