Adventure quest information Analysis - At the present they have a database and a spreadsheet to help them organise the whole park.

Authors Avatar

Unit B: handling information

Emmet Murphy

Quintin Kynaston school

Centre No. 10257

           

1. Introduction

My real user is Adventure Quest theme park

(Adventure quest information)

2. Analysis

2.1 At the present they have a database and a spreadsheet to help them organise the whole park. They use the database in order to control the bookings and events. They use the spreadsheets to keep track of running time of different types of rides.

2.2 problems with current system

  1. At the moment there is no relational database to link the bookings and the events table.
  2. Its not easy to query the database e.g. they need to sort the database using different search criteria.
  3. It’s not easy to create reports based on those queries.
  4. They want to have templates to use when creating spreadsheets different rides.
  5. They need spreadsheet to keep control of running course, loading time, queuing time, duration of ride.
  6. They need to produce charts showing all the information to be included in reports.

2.3 GENERAL OBJECTIVES

  1. They have to create the relational database to link the tables.
  2.  The new system should be able to search the database using different search criteria.
  3. The new system should be able to generate reports based on different queries.
  4. There should be templates available on the system to control the different rides.
  5.  The spreadsheet should be able to control running cost, loading time, queuing time and duration of ride.
  6.  The new system should be able to produce charts showing all the information to be included in reports.

2.4 Specific objectives]

1. They have to create the relational database to link the tables

Join now!

  1. Create the bookings table, Booking number, Customer ID, Date, Event Code, guest arrival time, deposit paid, staff ID.
  2. Create the EVENTS table. EVENTS (event code, event type, age, venue, max number, min number, cost per head)
  3. Link the two tables by using foreign key (event code)

2. Its not easy to query the database, e.g. they need to sort the database using different criteria.

2.1 All the events held in the terror zone

2.2 All events that hold at least 50 people and cost less than £30 per head

2.3 Bookings made for the ...

This is a preview of the whole essay