• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  • Level: GCSE
  • Subject: ICT
  • Word count: 1521

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

Extracts from this document...

Introduction

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. ...read more.

Middle

5.3 Enter a formula to calculate the total load-time for each ride. 5.4 The formula will use the value in ''Load-time per person'' cell (using an absolute cell reference or a named cell). 5.5 Use another column to add the load-time to the run-time to give the total ride time for each ride. 5.6 Sort the spreadsheet. Make sure that all columns are correctly sorted. 5.7 In a suitable cell, enter a formula that uses a function to calculate the average number of people waiting at any time. 5.8 Format the cell to numeric, 0 decimal places. 6.The new system should be able to produce charts showing all the information to be included in reports. 6.1 Use the spreadsheet to create a suitable bar/column chart on a separate sheet. 6.2 Legends should not be used. 6.3 The title, axis and label should be added to graph 2.5 System requirements Hardware requirements Input devices Output devices CPU (central processing unit) Storage Keyboard Mouse Scanner Printer Monitor Pentium III -1 giga hertz 512 Mega bytes memory 1.44 Mega byte floppy 20 memory bytes hard-disk Software requirements Objectives Software use 1,2,3 A database is simply a collection of data. The data could be kept in a card index file, in a filling cabinet or on a computer. There are many software packages that allow a user to create an electronic database that holds data in a convenient way. ...read more.

Conclusion

Field Name Data Type Length/Format Booking Num Text 5 Cust ID Text 7 Date Date/Time dd/mm/yyyy Event Code Numeric 3 Guests Numeric Integer Arrival Time Date/Time hh:mm Deposit Paid Currency � sign 0 d.p. Staff ID Text 4 Screen Input forms Bookings input form Bookings number Customer ID Date Event Code Entity Relationship diagram On EVENT can be booked many times, the relationship between EVENT and BOOKINGS 3.2 Screen input forms Objectives 1,2 and 3 EVENTS Table BOOKINGS Table Field Name Data Type Length/Format Event Code Text 3 Event Type Text 20 Age Text 8 Venue Text 20 Max Number Numeric Integer Min Number Numeric Integer Cost per head Currency � sign 2 d.p. Field Name Data Type Length/Format Booking Num Text 5 Cust ID Text 7 Date Date/Time dd/mm/yyyy Event Code Numeric 3 Guests Numeric Integer Arrival Time Date/Time hh:mm Deposit Paid Currency � sign 0 d.p. Staff ID Text 4 3.3 Spreadsheet design Objectives 4,5 and 6 One EVENT can be booked many times, the relationship between EVENT and BOOKING is one-to-many. EVENT is on the one side of the relationship and the BOOKINGS are on the other side. Section 4 Implementation Database (task1) To create a BOOKINGS table (to include: bookings number, Additional Requirements 1) Create a chart showing in % the amount of time people spend on a ride (loading/ride times) 2) Search for all adult events. Display cost per head Deposit Event Date of events 3) Additional IF statement That checks if waiting times are reasonable or unreasonable ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Software essays

  1. Design a spreadsheet that can be used by a school tuck shop.

    I then checked to see what happened to spreadsheets further along in my workbook and this is what I found happened: * The Profit cell changed its function and added in the extra row and so found a new total including the new product line.

  2. Planning a spreadsheet database for a gun shop.

    adding 5 If Calculations are right Test the calculation by observing if the answer is right. Answer should be right. Burma Road Birmingham Bra 4bb Tel: 06531234321 Dear Mr Butt I would to say well done to you for your hard work I received your final design and I would

  1. Documentation of a database for a sports centre.

    and shows the emails of these people. Form Design Forms are used to observe the data in a database. They can also be used to find one way from one section to another. When designing forms it is essential to show the actual layout of the form; design, style, fonts,

  2. Reviewing different multimedia presentations.

    This is a good feature because it enables you to contact the people who crated this Multimedia Presentation if you want to as this is an adverting Multimedia Presentation. 2. Not so good features of the multimedia product: The first not so good feature is that there are no animations

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    I decided to have my data sorted by the surname in ascending order, as student names are often organised in this way in most schools. Step 7 I then added the headings I wanted in my table, by typing them into the specific cell.

  2. Desktop Publishing - Analysis

    The backup will be saved every time the magazine is changed, and will also be password protected, so no-one without authorisation can use it. Process * I will open a desktop publishing program * I will open a new template * I will save the template * I will copy

  1. Analysis section for database project based on a hotel booking system

    I have also decided to carry on this project using a relational database software package. This is because of the below reasons: 1. Database application packages are specifically designed to create computer-based files to store and process information in place of manual filling systems such as the one in use at Luxury Hotel.

  2. bookings database

    You can not book a room for 20 years. This check is effective because when the user is busy and/or frustrated, they can enter a wrong departure/arrival date etc. 9. Can't book a room already booked- when the user books a room already booked for the dates (arrival and departure date), an error message appears.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work