• 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

# Related GCSE Software essays

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

It can be customized to suit the needs of the users and they contain tailor-made solutions that are almost as good as writing a special computer program. 3. Due to it customized nature, it is found to be very user friendly 4.

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. ## 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. ## Database Hajj&amp;amp;Umrah travel agency

For example I will use: * Keyboard - To enter data, i.e. numbers, text * Mouse - To click on icons and options * Monitor - To look at the data visually on the screen * CD - To save on to a CD-ROM SOFTWARE USED I will be using

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.

The second good feature of the Multimedia Presentation is that when you hover your mouse over one of the titles at the top there is a graphic which starts to move on the right which adds some movement to the Multimedia Presentation.