• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  • Level: GCSE
  • Subject: ICT
  • Word count: 3077

A Design Specification for an ICT System Introduction Going places is one of the biggest travel agents in the UK.

Extracts from this document...


2C - A Design Specification for an ICT System Introduction Going places is one of the biggest travel agents in the UK. When thinking of a way to allow customers to book holidays themselves, they came up with the idea for a new self-service kiosk to be situated in-store. Customers using this innovative system need to be able to view various holidays, search for ones they are interested in, and book holidays once they have decided on the deal they want. This would be particularly convenient for staff as they would not need to speak to individual customers using this method. At present, the only way to view existing holidays is to browse the cards displayed in the shop window. Brochures are also available, however, that contain information about holidays, but essentially all clients need to speak to a travel agent to arrange a holiday. Going Places' new system needs to permit customers to: * Browse holidays currently on offer * Search for holidays matching their requirements * Receive a letter in order to confirm their holiday * details Going Places staff need to be able to use this system to update users and holidays, but also to search and browse holidays and users. In this piece of coursework I will be exploring how a database can be created to suit all of Going Places' needs. I will plan a database that they could use for their new self-service kiosks. Going Places offer a range of high-quality holidays. They are available to the public at reasonable prices, with all sorts of deals depending on the destination you want to visit, and the number of people going on holiday. They are a very successful company, and are one of Britain's most popular travel agents. Some of their competitors are 'Thomas Cook', another travel agent that is doing well, and offers similar products to Going Places, and 'Virgin Holidays', another successful company. ...read more.


Sun Duration Text 10 Length of time the holiday lasts. 2 weeks Star Rating Number 1 Holiday rating out of 5 4 Date Text 15 Date of departure. 10th August Table Name Field Name Data Type Field Length Comments Example of Data Enquiry Enquiry ID Autonumber - ID of the enquiry. 6648300 Customer ID Autonumber - ID of the customer. 2166533 Holiday ID Autonumber - ID of the holiday. 7644564 Would you like to receive updates by phone? Yes/No - Whether the customer wants to receive calls from Going Places. No Comments Text 50 Any comments the customer might have. Hotel preferably with swimming pool. Would you like to receive updates by email? Yes/No - Whether the customer wants to receive emails from Going Places. Yes Inputs, Processes and Outputs Input Process Output Input Forms Information can be inputted into the database using the following input forms: This is the form for customers to enter their personal information. This is the form for staff to enter holiday details. http://www.goingplaces.co.uk/ Feb 2008 This is the form for customers to enter their enquiry details. Query Designs There are many queries, which are very useful for when customers wish to search for a particular holiday, that could be performed using my database. For instance: Query 1: 'Show me all the holidays in Spain'. Tables: Holiday. The holiday table needs to be searched to find relevant results. Fields: Country, City, Hotel. All these fields can be searched to find a holiday that would fit the bill. Criteria: 'Spain'. This will be queried in the appropriate fields Results should be presented in ascending order based on either price or star rating. They can be put into a report for the customer to view or print. Query 2: 'Show me all family holidays in Spain or Portugal'. Tables: Holiday. Fields: Country, City, Hotel, Type of Holiday Criteria: 'Spain', 'Portugal', 'Family holiday' Results should be presented in ascending order based on either price or star rating. ...read more.


ID: Enter a Valid Enquiry ID 6038029 6038029 T42 Enquiry ID: Enter an Invalid Enquiry ID #~'#;lljebutas Error Message T43 Customer ID: Enter a Valid Customer ID 1047528 1047528 T44 Customer ID: Enter an Invalid Customer ID HHasEllepqp9acfde Error Message T45 Holiday ID: Enter a Valid Holiday ID 7293847 7293847 T46 Holiday ID: Enter an Invalid Holiday ID '6pos6m6566trophe6' Error Message T47 Please email: Enter Valid email jack.remi@kalil.com jack.remi@kalil.com T48 Please email: Enter Invalid email hnssdYt45gh''# Error Message T49 Please phone: Enter valid number 01593 837221 01593 837221 T50 Please phone: Enter Invalid number {{}{{ukik)'?? Error Message T51 Comments: Enter a valid comment We had a great time, thanks Going Places! We had a great time, thanks Going Places! T52 Comments: Enter an Invalid comment @''';356#l][='@ Error Message T53 Would you like to receive updates by email?: Select Valid 'no' No No T54 Would you like to receive updates by email?: Select Invalidnothing Error Message Reports I need to make sure that all my reports look professional. To do this I will guarantee that all the correct data is taken out of my database. There will be no duplicate information or incorrect spacing, such as column widths not making sense, and everything will be spelled correctly. Mail Merge Letter The mail merge letter must also look professional as well as friendly. Spacing needs to be right, again, as well as all the spelling. The information from the database (highlighted in the letter) must also be correct, with no duplicate information. Project Plan Date (2 periods - 100mins) 18.02.2008 Homework 25.02.2008 Homework 03.03.2008 Homework 10.03.2008 Homework 17.03.2008 Homework 07.04.2008 Homework 14.04.2008 Homework Tasks Create Database Create all 3 Tables Enter Fields Enter Data Types Enter Field Lengths Enter Customer Records Enter Holiday Records Test Database Tables Creat Input Forms Test Input Forms and Add Data Create Queries Create Query Test Create Reports Customize Reports Test Reports Create Mail Merge Letter Test Mail Merge Letter ?? ?? ?? ?? AGCSE ICT Unit 2c - 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. Marked by a teacher

    Planning- design a memo, letter and webpage for Capital FM.

    4 star(s)

    * The homepage must have the same house style as the other documents * This will be a lot quicker and simpler as you just use the one document to open all the other related documents. Alternative Possible Solutions A non ICT solution for the letter is that you could

  2. Peer reviewed

    Designing a database for Type a Flight Travel Agent.

    3 star(s)

    I can also do this task by Microsoft Word but will not use this method because Microsoft Word does not have as many drawing tools and functions as Microsoft Paint which means it is not as easy to draw on Microsoft Word as it is on Microsoft Paint.

  1. Different types of technology How I use ICT at home and at school

    In the end, it tempted me to just get both which ended up making it really expensive for me. It's also extremely addictive, time wasting and distractive. In the end, gaming doesn't add much productively unless it's on an educational platform.


    Graph and charts should be generated quickly and easily to compare boys and girls performance, All student and by form. 8. It should automatically use colour code for student grades. It should be able to add and delete/ edit students if required.

  1. Creating a computer system for a video rental shop

    fine reports Requesting report Videos out report Tables The tables are linked together to make a relational database. The tables are linked by means of a common field. One of the common fields must be a key field and the other is known as a foreign key.

  2. ICT Report 2b: ICT in Organisations

    systems are placed at the entrances/exits of Boots' branches as an anti-shoplifting technological method (aside from CCTV). Three types of EAS systems dominate the retail industry. In each case, an EAS tag or label (usually with the barcode on it)

  1. Design specification for an IT system for Harry's Dog Kennel business.

    fully tested so a minimum amount of errors can occur when the solution is passed over to Harry and his employees * must make Harry?s jobs more organized and efficient * let certain data to be searched for within the spreadsheet * When you alter a cell , the data

  2. ICT Specification for a spreadsheet for the Hairdressing business.

    make sure it has appeared on my database the way I have wanted it to turn out. Testing made sure that all the specification points were all able to be fulfilled and achieved but at the same time realistic in order for me to carry them out efficiently.

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