Designing a database for Type a Flight Travel Agent.

Authors Avatar

AO2a

Introduction

I have been given a task to make things easier for a travel agent called Type a Flight. Type a Flight is a travel agent which is situated in Warrington and it was established in 1995, it’s been 16 years now and it also has about 500 customers and 10 employees. The company does all its work manually. They keep their documents in filing cabinets. So when customers call in to book flights then they have to look in the cabinets for a document. This is very time consuming and due to this problem they could lose a fantastic amount of customers because they could get tired on the phone. Filing cabinets also take up a lot of space. This is getting very difficult and time consuming as the number of customers is rising on a daily basis. One of the problems is that it takes time writing letters by hand .For this problem I have come to the conclusion to make their things easier by making a database for them so it will be effortless for them to sort things out and make bookings, rather than wasting time searching through filling cabinets, plus if they had a database they will have more satisfied customers due to the fact that they will be able to work more quicker using a database. Another advantage of having a database is that they can serve more customers at the same time.

One of the problems is that it is time consuming to keep on writing new letters by hand so I have come to the conclusion of designing template letters. The advantage of this solution is that it saves time because the staff members do not have to write the letters out by hand instead they can post the template letters to the customers’ houses.

Join now!

I have decided to create a database for type a flight so that there is less time being consumed. Instead of searching through your filling cabinet they will have a database so when a customer rings in, it will be easier to book their appointment. Therefore the company will become more popular.

Research

The type of database I have looked at was a sample database called type of flight. It contained stuff like if you have signed up or not, so you know if you will need to register. 

Database: Type a Flight

Comment: The switchboard ...

This is a preview of the whole essay

Here's what a star student thought of this essay

Spelling, grammar and punctuation are generally good, but the piece is filled with short sentences which could be expanded upon. Rather than addressing the points in an almost bullet-pointed list, you should write it in continuous prose to make it look and read better, and the extra information you would need to put in to make it continuous would also help improve your mark. Technical terms are usually used where appropriate, however you have also used very informal language such as “it contained stuff…” which does not belong in this formal planning report.

You have not chosen suitable programs for this piece of work. As a serious alternative, you have suggested pen and paper, which is not suitable for the reasons you have detailed at the beginning of the report, so a short note would suffice. You have suggested programs such as WordPad as an alternative to Word, which I have detailed above. For the logo task, you have chosen Paint as your preferred program, with Word as its alternative. At GCSE, you should know of programs such as Photoshop, as well as possibly GIMP and Fireworks. You may not be able to use them or have access to them, but if you detailed why these are good and why you can’t use them – even if you don’t know how – you will show that you are aware of the best programs to use and gain those marks. You have however successfully chosen Access or Open Office Base for the database task, which is a good choice and knowledge of functions and alternatives.

This piece answers the question but doesn’t do anything more to get a high mark. You have clearly planned the task and identified the subtasks and problems with the current system well, but the subsequent planning of the subtasks is very basic. You have written very little in each section and what you have written seems to be the bare minimum to meet the requirements. For example, you have chosen WordPad as an alternative to Word for such a task, where WordPad would technically suffice, it would not be used by anyone attempting the task, and such is not an appropriate alternative to compare it to.