• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Online booking system Database

Extracts from this document...


Ajay Patel Reasons for the categories in my Database I have had to make a database which will soon be linked to the online booking system which will also soon be created in Microsoft FrontPage. The reason why I had to make a database is so that the information which will be needed for the online booking system can be kept in the database. After examining many other online booking forms, the majority of them for cinemas I decided to make a list of all of the information which I will have to keep in my database and the reasons why I believe that it is appropriate to keep this information. The categories which I have decided to put into my database and then link up to my online booking system are; 1. Title 2. Forename 3. Surname 4. Address 5. Name of Film 6. Time of Film 7. Start time of Film 8. Finish Time of film 9. Certificate 10. Screen Number 11. Email Address 12. Number of Tickets @ Adult price 13. Number of Tickets @ Child's price 14. Number of Tickets @ OAP price 15. Number of Tickets @ Student price 16. Number of Tickets in Total 17. Ticket Collection Number Those are the seventeen different categories which I decided to include into my database. The reason why I have included these are because; Title The reason why I decided to include this in my database is because; I feel that it is important to know whether the person whom is buying the tickets ...read more.


Time of Film/ Start/ Finish The reason why I have decided to include this category into my database is because; it is important that the customer knows when the film is scheduled to start and finish. The time of the film and the start of the film are slightly different in certain ways. I believe that the time of the film should be taken back 10 minuets from the scheduled time of the film time, just in case of any problems which may occur. The start of the film is the actual time that the film will actually commence. It is also important to put the time that the film finishes just in case the customers have to do something afterwards and they will require the running time of the film and the approximated finish time. With this information the customers will be able to decide whether they will have enough time to get to their next destination after the film. Also, it is a general guide to show how long the film is. The reason why I feel this information is crucial is because; this information is what people base coming to the cinema on, the fact whether they can make it or not. Certificate It is vital that we put the certificate of the films. The reason for this is because; the customers know whether the film is suitable for all, and whether they can take their children to the cinemas to watch certain films. ...read more.


Ticket Collection Number The reason why I have decided to put this on is because; the tickets are usually printed off and if the customer doesn't have a printer then he can acquire the collection number and go to the special stands in the cinema to pick up his tickets, this will be quick and he/she wont have to wait in the queue for a very long time. This is also a number which contains the record of the certain order which is being processed. The number will hold the entire order in it, so this is also another verification method which can be used to make sure that the order is acceptable and to make sure that the customer knows what he is buying and for how much he is buying it for. Credit Card Information There will obviously have to be information on the booking system about the customer's credit card. The information will be entered but it won't be saved into out databases. The reason for this is because; there is too much of a high risk keeping very personal details like credit card numbers which can lead to fraudulent uses of cards if a server was hacked into and various card numbers where stolen. That is the reason why this information will be not kept in the database. Nevertheless we will use an ssl encrypted security procedure to make sure that the credit card information is kept secret and not hacked into whilst the order is being processed online. This is one of the most reliable and the most up-to-date methods of making sure that the credit card number is not stolen. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level ICT in Business 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 AS and A Level ICT in Business essays

  1. Marked by a teacher

    business online

    4 star(s)

    Tesco was founded by Jack Cohen, who served with the Royal Air Force during the First World War. After returning in 1919, 21 year old Jack invested 30 pounds of his reward for military service to buy surplus food stockpiles and he opened a little stall in East London.

  2. Business Online

    principle of sustainable development, meeting the requirements of the present without compromising future generations; these are the futures aims of the company: ?Tesco, its directors, officers and employees will at all times obey with all applicable laws and regulations relating to the environment.

  1. Critical Success of PVR cinemas in India

    * First to introduce "Heritage Cinemas" in India * First to form a "Foreign Joint Venture" with Village Road show, Australia * First to receive "Institutional Funding" in the cinema industry - from ICICI * First to offer "Computerized & Online Ticketing" * First to introduce "Real Time Ticketing" on

  2. The purpose of the new system is to extend the current computerised room booking ...

    People outside of the college organisation have to pay. This is charged hourly per room and the minimum hire rate for up to 3 hours is �40. A 5% discount may be received for multiple bookings of more than 6 booking in any term and a further discount may be considered for recognised, registered charities.

  1. Apple Incorporation - Case Analysis

    05, 2004 is estimated at 294,444,408. This is an increase of 13 million people in just a little over four years. Increases in population combined with the advances in technology will continue to drive increased sales in future computer markets (Factfinder.census, 2004).

  2. Designing a film poster for the film S.W.A.T.

    I think this poster is fantastic. It shows all of the main characters on the up part of the page and there is a hand which is holding a bow below the characters - this is likely to show the atmosphere of the film and it makes the posters seems very obvious.

  1. E-commerce case study - Online Music Bussiness.

    Then we have the hardware industry which produces, CD-player, or mp3 players, like Sony, Philips, Nokia, HP, IBM, Ericsson. However there will effects on these stakeholders which include: 1. The cost and the way payment is made are likely to change.

  2. Investigating Electronic Business. In this section I will be choosing two similar business ...

    on how they think the company is performing and if they are satisfied with their service. This can be done direct, and the company will receive it as soon as it is sent. This information can they be used to improve the company and cater for any particular consumer needs.

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