• 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

    Then it would give you a price at meals per person (picture 1). However further down the spreadsheet you can still enter A catering firm and the price will still appear (picture 2) changing the overall total to be more than what it should be.

  2. ICT PROJECT

    Enter within boundary data e.g. 60 To see how validation system accept the right data Data should enter without a problems 30. At boundary data e.g. 99 To see how system reacts to correct data Should enter data without difficulties 31.

  1. This project is designed to help non-computerized library to easily keep track of their ...

    the library to buy books, if a member wanted a book that the library didn't have then the librarian could put that certain book in the next stock list of books sent off to the supplier of the books. So what would happen is that the pupil or teacher would

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

    Currently you have the game for three weeks. These green cards and then stored in a box in the managers office. The oldest loans will be at the back of the pile and the newer loans will be at the front. The employee/manager then stamps the piece of paper inside when the game should be due back.

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

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

  1. Computer project Alevels

    Once the username and password is correctly typed in, the main menu appears as shown below giving you a chance to make your selections. Here there are many options for the user to select according to his/her need. I have grouped these selections according their categories.

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

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