Find Jobs
Hire Freelancers

DATABASE

$100-200 USD

Terminado
Publicado hace alrededor de 20 años

$100-200 USD

Pagado a la entrega
** ** 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
ID del proyecto: 3099348

Información sobre el proyecto

10 propuestas
Proyecto remoto
Activo hace 20 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
See private message.
$119 USD en 10 días
5,0 (27 comentarios)
4,1
4,1
10 freelancers están ofertando un promedio de $148 USD por este trabajo
Avatar del usuario
See private message.
$148,75 USD en 10 días
4,9 (62 comentarios)
5,4
5,4
Avatar del usuario
See private message.
$170 USD en 10 días
4,7 (25 comentarios)
5,2
5,2
Avatar del usuario
See private message.
$144,50 USD en 10 días
5,0 (13 comentarios)
3,9
3,9
Avatar del usuario
See private message.
$127,50 USD en 10 días
4,8 (27 comentarios)
3,7
3,7
Avatar del usuario
See private message.
$168,30 USD en 10 días
4,5 (10 comentarios)
3,5
3,5
Avatar del usuario
See private message.
$170 USD en 10 días
4,9 (26 comentarios)
2,9
2,9
Avatar del usuario
See private message.
$110,50 USD en 10 días
4,7 (9 comentarios)
2,6
2,6
Avatar del usuario
See private message.
$170 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
See private message.
$153 USD en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
United Kingdom
0,0
0
Miembro desde feb 13, 2004

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.