Oracle SQL * plus

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.

Техніка MySQL Oracle PHP Архітектура ПЗ Тестування ПЗ

ID Проекту: #3111507

Про проект