can anyone help me in this travel agency design ?? plz
Travel agency management system
A travel agent wishes to create a database for its customer holiday booking activities. The travel agent has numerous branches spread through the major cities in the country. A customer can call into, or contact by telephone, any branch and book for a holiday. A holiday normally includes a flight and accommodation, although sometimes customers require only a flight or accommodation.
Once the agent has found a suitable holiday for a customer, the flight and accommodation requirements are reserved for the customer. However, the reservation can only be held for up to 24 hours by which time the customer must accept or decline the booking. Once the booking is accepted, the customer is invoiced for the holiday and must pay the invoice in full, a minimum of four weeks before the departure date. The name of the employee who initially processes the customer booking is recorded.
You are required to design and implement (create) a database as part of an information system to support the travel agency processes.