Quintin Kynaston school Essay Example

Quintin Kynaston school Essay Example Quintin Kynaston school Essay Quintin Kynaston school Essay 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 system1. 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. Its 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 OBJECTIVES1. 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 tables1.1 Create the bookings table, Booking number, Customer ID, Date, Event Code, guest arrival time, deposit paid, staff ID.1.2 Create the EVENTS table. EVENTS (event code, event type, age, venue, max number, min number, cost per head)1.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 zone2.2 All events that hold at least 50 people and cost less than à ¯Ã‚ ¿Ã‚ ½30 per head2.3 Bookings made for the 7th and 8th May 20032.4 Details of bookings for birthdays for kids.3. The new system should be able to generate reports based on different queries3.1 generate reports about all the events held in the terror zone.3.2 Generate reports about all events that hold at least 50 people and cost less than à ¯Ã‚ ¿Ã‚ ½30 per head.3.3 Generate report about Bookings made for the 7th and 8th May 20033.4 Generate a report about details of Bookings for birthdays for kids.4. There should be templates available on the system to control the different rides.4.1 Create a spreadsheet template for the new ride.4.2 Enter a formula to calculate the total time for the first feature.4.3 Copy the formula down for all the other features.4.4 Insert a formula that uses a function to calculate the total runtime.4.5 Make the name of the park larger than the rest of the text.4.6 Make sure that the spreadsheet is clearly presented and easy to use.5. The spreadsheet should be able to control running cost, loading time, queu ing time, and duration for ride.5.1 Create a spreadsheet to show the rides, run-times and capacity.5.2 Enter a label Load-time in the column next to Total time.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 graph2.5 System requirementsHardware requ irementsInput devicesOutput devicesCPU (central processing unit)StorageKeyboardMouseScannerPrinterMonitorPentium III -1 giga hertz512 Mega bytes memory1.44 Mega byte floppy20 memory bytes hard-diskSoftware requirementsObjectivesSoftware use1,2,3A 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. The data can then be input, sorted, searched and reports produced. Data in a database is held in tables. Some database packages such as MS works only allow one table per database. Other packages such as MS access allow the creation of many linked or related tables in a single4,5,6Spreadsheets are used for organising and analysing numerical information. Imagine that you are in charge of planning a ski holiday with a group of friends. You have chosen your destination, and now you have to choose the me thod of travel, accommodation, ski lift passes/lessons etc to fit with each persons budget. A Microsoft Excel spreadsheet model will help you do this.Im going to use a word processor to write down this report.Section 2.6 Input-processing-outputObjectives 1,2 and 3Input: Bookings and Events table kept by Adventure QuestProcessing: find all the events held in the terror zone.Find all events that hold at least 50 people and cost less than à ¯Ã‚ ¿Ã‚ ½30 per head.Find all Bookings made for the 7th and 8th May 2003.Find all the details of Bookings for Birthdays for kids.Output:Generate reports about all events held in the Terror zoneGenerate reports about all events that hold at least 50 people and cost less than à ¯Ã‚ ¿Ã‚ ½30 per head.Generate report about Bookings made for the 7th and 8th May 2003Generate reports including details of bookings for Birthdays for kids.Objectives 4,5 and 6Input: Running times for each feature, number of features in each ride, Loading time, and queuing tim eProcessing: Total run time for each ride, Load time per ride, average number of people waiting at any time, total run costOutput: Chart showing, total run time for each ride, chart showing load time per ride, chart showing average number of people waiting at any time, chart showing total runSection 3.3 DesignsObjectives 1,2 and 3Data dictionary: Includeedexcel.org.uk/virtualcontent/69144.pdfField Name:Data Type:Field Length:Comment:EVENTS TableBOOKINGS TableField Name Data Type Length/FormatEvent Code Text 3Event Type Text 20Age Text 8Venue Text 20Max Number Numeric IntegerMin Number Numeric IntegerCost per head Currency à ¯Ã‚ ¿Ã‚ ½ sign 2 d.p.Field Name Data Type Length/FormatBooking Num Text 5Cust ID Text 7Date Date/Time dd/mm/yyyyEvent Code Numeric 3Guests Numeric IntegerArrival Time Date/Time hh:mmDeposit Paid Currency à ¯Ã‚ ¿Ã‚ ½ sign 0 d.p.Staff ID Text 4Screen Input formsBookings input formBookings numberCustomer IDDateEvent CodeEntity Relationship diagramOn EVENT can be b ooked many times, the relationship between EVENT and BOOKINGS3.2 Screen input formsObjectives 1,2 and 3EVENTS TableBOOKINGS TableField Name Data Type Length/FormatEvent Code Text 3Event Type Text 20Age Text 8Venue Text 20Max Number Numeric IntegerMin Number Numeric IntegerCost per head Currency à ¯Ã‚ ¿Ã‚ ½ sign 2 d.p.Field Name Data Type Length/FormatBooking Num Text 5Cust ID Text 7Date Date/Time dd/mm/yyyyEvent Code Numeric 3Guests Numeric IntegerArrival Time Date/Time hh:mmDeposit Paid Currency à ¯Ã‚ ¿Ã‚ ½ sign 0 d.p.Staff ID Text 43.3 Spreadsheet designObjectives 4,5 and 6One 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 ImplementationDatabase (task1)To create a BOOKINGS table (to include: bookings number,Additional Requirements1) 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 headDepositEventDate of events3) Additional IF statementThat checks if waiting times are reasonable or unreasonable