** **
Oracle SQL*Plus, Oracle Forms and Oracle Reports.
**2. Case Study**
Dreamland is well-known for their reputation in organising high profile business and social functions. Customers initially discuss their requirements for a particular function with one of Dreamland’s Marketing Consultants. The Consultant will then complete a Function Requirements Form, an example of which is given in Figure 1. Each function lasts one day, and a multi-day function will be treated as a series of separate functions. A function will usually require both equipment, e.g. Sony Camcorder, and personnel, e.g. magician. The Marketing Consultant will calculate the total cost of providing these services, and then give a copy of the completed Function
Requirements Form to the customer. If the customer accepts the quotation, a copy of the form is forwarded to the Office Manager.
In addition, the Office Manager generate various reports either on a regular basis or when required, for example, Monthly Equipment Usage Reports (given in Figure 2), Monthly Staff Duty Reports, and Customer Invoices.
**other information will be provided**
## Deliverables
The requirements are:
_ An entity relationship model for the system.
_ A set of fully normalised tables for the system
_ You may use Figure 1 as a starting point for normalisation.
_ You may also add additional attributes where appropriate.
_ A data dictionary for the system.
_ Generation of the tables for the system, based on your normalisation
outcome, using Oracle SQL*Plus.
_ Implementation of the following forms using Oracle Forms:
_ Basic Forms:
_ Customer Details Form
_ Staff Details Form
_ Equipment Details Form
_ Function Details Form
All these forms should facilitate input, update and delete of information.
_ Function-Staff Schedule Form (for any scheduled function, show all the
staff assigned to it)
This form should facilitate the allocation of existing staff to an existing
function.
_ Function-Equipment Schedule Form (For any scheduled function,
show all the equipment required)
This form should facilitate the allocation of existing equipment to an
existing function.
_ Function Requirements Form, as a slightly modified version of the form
given in Figure 1 (for any scheduled function, show the details of the
function, customer, and staff and equipment requirement).
_ Implementation of the following reports using Oracle Reports:
_ Monthly Equipment Usage report, as a slightly modified version of the
report given in Figure 2 (For each piece of equipment, list all the
functions for which it is used during the specified month).
This report should contain at least 4 types of equipment, and one of
them should be used in more than two functions).
7
_ Monthly Staff Duty Report (For any staff member, list all the functions
to which he or she is allocated during the specified month).
This report should contain a staff member who is allocated to more
than two functions.
_ Implementation of a front-end screen which allows for access using buttons to
the forms and reports you have implemented.
## Platform
I REQUIRE THIS SYSTEM TO RUN USING ORALCE FORMS