... 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 1.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 ...

See this essay or coursework document in full right now