Booking Systems
If you book a holiday, a theatre or cinema ticket, a train ticket, or a room in a hotel, there will probably be a computerised booking system processing it.

Many booking systems are now web-based and bookings can be made over the Internet.

The customer can search to find out what bookings are available, and then make and pay for the booking.

 

Web-based booking systems are plentiful...

... and provide an easy way of making a booking from the comfort of your own home.


Every booking system will have a database. This will include...
  • Bookings table - storing fields such as BookingID, Date, CustomerID, Price,...
  • Customers table -storing fields such as CustomerID, CustomerName, CustomerAddress, ...

One big advantage of a computerised booking system is that there should be no double-booking - two people booking the same item.

A booking system is an example of a real-time transaction system.

 

Input :
  • details of the booking from the customer.
  • details of the customer
  • data from the bookings database about availability.
Processing :
  • check availability
  • validate customer details
  • update of bookings database
  • process of payment
Output :
  • customer details and booking details output to the bookings database
  • booking confirmation given to customer
  • printed reports on bookings
On-line booking systems provide fast and convenient ways to make bookings.