CS4400 Database Project
Handyman Tools Rental
Fall Semester, 2004
1. Purpose of the Project
Analyze, specify, design, implement, document and demonstrate an information system
application to support the operation of the Handyman Tools online tool rental service.
You are required to use the Classical Methodology for Database Development. The
system must be implemented on ORACLE available on ACME. The professor must
approve other alternative implementations.
2. Project Phases
The three phases of the project cover the following work-processes from the Classical
Methodology for Database Development.
I Analysis & Specification September 24
III Implementation & Testing November 29
Projects with Lightweight phase III may have 3 members.
Projects with JDBC/Java GUI may have 4 members.
A group may remove a member from further participation in the group when Phase I is
turned in or when Phase II is turned in. A written notification must be provided to the
professor at that time.
A typed report is handed in for grading at the end of each phase.
The Phase I Report must contain a description of the purpose of the project and the purpose of
this phase of the project. It must describe the problems encountered in the technical requirements
of this phase and justify the solutions. It must contain all documentation produced in this phase,
including Information Flow Diagrams, E-R Diagrams, and Task Forms.
The Phase II Report must contain a description of the purpose of this phase of the project. It must
contain the Phase I Report and must describe any revisions made to the specification described in
the Phase I Report. It must further describe the problems encountered in Phase II and justify the
solutions. It must contain all documentation produced in Phase II with the addition of a relational
schema, and abstract code with SQL (for each task). The relational schema specification should