• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 2612

I have been asked to come in and help out a holiday company called First Choice. I have been asked to help them work out a new system to make things a lot easier and simple for the employees and the customers.

Extracts from this document...

Introduction

Analysis My name is Natalie Howard and I have been asked to come in and help out a holiday company called First Choice. I have been asked to help them work out a new system to make things a lot easier and simple for the employees and the customers. I have been asked to do this because the present system they are using at the moment takes to much time up and it is too complicated. With the present system things like customers information, booking details and flight details are getting mixed up and it also takes a lot of time to find out what you are looking for. If we work out a new system to use instead of the one we are using at the moment then it will make it a lot easier to find out details about customers, flights, prices etc. Project Proposal Project title Air Tours Aims of project To investigate and try solving information handling problems of Air Tours agents. I have been asked to design and set up a more sufficient way of storing and handling information about the customers the bookings and the holidays. Inputs Processing Outputs Customer details Holiday details Booking details Price of holiday What board it is Destination What * the hotel/accommodation is Flight details Amount of people going Look up customer details Look up holiday details Look up booking details Look up price Look up what board it is Look up the destination Look up what * it is Look up flight details Look up amount of people going Customer details Holiday details Booking details Price Board e.g. ...read more.

Middle

record; * It must take no more than 2 minutes to find and edit a customer, holiday or booking record; * It must take no more than two minutes to edit the amount of money still to be paid. * It must take no more than two minutes to create a new a new customer, or booking record; * It must take no longer than two minutes to find customers still needing to pay money * On screen data entry forms must be clearly laid out to make data entry; * On screen data entry forms must use automatic data validation to reduce data errors on input; * It must take no longer than 2 minutes to search for customers due to depart on certain date and produce a list that can be printed out; * It must take no longer than 5 minutes to search for all the customers with an holiday coming up within the next month and produce a summary report on screen; * Reminder letters to customers with holidays coming up and should be clearly laid out and include all the details of the holiday, tickets and of money that needs to be paid relevant information that needs to be sent to the customer. * It is difficult to work out how much money each customer has paid and how much money is still to be paid. * The money is taken before the holiday has been confirmed. This causes confusion and mistakes if the holiday they've paid for is not available. ...read more.

Conclusion

Holiday tables Table one Field name Data type Validation rule Description Typical data Holiday ID Number Number used to identify a holiday 4 Country Text Country of holiday Canary Islands Resort Text Resort of holiday Tenerife Price Currency Price of holiday �430 Accommodation Text Accommodation of holiday Hotel Table two Field name Data type Validation rule Description Typical data Holiday ID Number Number used to identify a holiday 4 Country Text Country of holiday Canary Islands Resort Text Resort of holiday Tenerife Price Currency Price of holiday �450 I have decided to choose table one because if a customer wanted to know what facilities there are then I would be able to tell them because I have the information about the accommodations in the first table. Booking tables Table one Field name Data type Validation rule Description Typical data Booking ID Number Number used to identify a booking 6 Holiday ID Number Number used to identify a holiday 8 Customer ID Number Number used to identify a customer 2 Table two Field name Data type Validation rule Description Typical data Booking ID Number Number used to identify a booking 6 Holiday ID Number Number used to identify a holiday 8 Customer ID Number Number used to identify a customer 2 Flight out Date Date floe out Monday Flight back Date Date floe back Friday I have decided to choose the second table because If a customer wanted to no the date they fly out and return then I would be able to tell them because I will have the information about the flights. The primary keys for all the tables are all the top left hand corner ID's. Natalie Howard Page 2 Natalie Howard Page 1 ...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 ICT Systems and Application 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 ICT Systems and Application essays

  1. Financial Model to help organise the year eleven prom

    This certainly could make the school lose a profit. (Picture 1) (Picture 2) So after carefully thinking about it, I decided to change the catering firm formula from a normal "Vlookup formula" to a "Vlookup" within a "if" formula. This then would give a more accurate price and could increase the profit entirely.

  2. ICT PROJECT

    Click on add new student and then click on 'cancel' button To make sure macro behind cancel button works correctly. Inserted row should be deleted and user taken back to front end menu 36. Delete all names in student list and try to enter a new record To ensure macro

  1. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    Then the member takes the game away and plays it. When someone returns the game they give it to the employee/manager. He/she then searches through the green cards to find the find the matching card. Then the employee/manager removes the details of the loan by scribbling it out or by using tippex.

  2. My task is to help Type a Flight travel agency to make their things ...

    Database: Type a flight Comment: I looked at a switchboard called "Type of flight" and the logo is situated in the middle of the page. It has various buttons such as Enter ID, Search ID, Gender, D.O.B, Name etc. This makes the database faster and sufficient.

  1. Benefits of using my IT system in the Travel Agents.

    you can use the Pencil to draw difficult shapes. * If you click on the Fill with Colour tool then you can paint your logo by selecting a colour of your choice. * If you click onto the Text tool then you can insert text into your logo. Saving * First, you click on File.

  2. Computer project Alevels

    Page number can be entered under "Page Footer". * Text boxes can also be entered in to the report. This can be done by clicking on the "text Box" button in the toolbox which as an icon of ab. Then the text box can be placed where ever needed in the report.

  1. I have been assigned a task to help International Dreams Travel Agency to make ...

    It has things like if you already signed up or if not then you can register but only staff can use this database. Also it has things such as if you are recommended by a friend and if you want to recommend a friend.

  2. Travel Agent Database - Effects of New System The new system will affect ...

    An advantage is that it is suitable for a person who has not used a computer. The reason why it shall be easy for him is that the documents will be arranged in alphabetical order. The disadvantages are that; it is unprofessional and takes up a lot of space.

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