MySQL - Holiday Builder |
Contact: Richard Hall |
The object of this project is to provide travel customers the ability to combine flight contracts with accommodation contracts in order to display dynamic holiday prices through a web browser. Another fundament will be the ability to edit and create the clients own tables also on the web live to negate the need to ftp databases. There are a number of tables in the database structure that would be common to multiple customers so we would also look at hosting the common tables on mydomain.com rather than duplicating them on each clients website. |
Project Outline |
Create a single asp page that can be used to pull holiday results from the MySQL database based on selected destinations. All flights at this stage of development are based on UK departure points. The date selection process will be common for all holiday destinations but the destination selections will be filtered depending on the query. If the page is holidays.asp then a user would select 'caribbean holidays'. They would enter their dates and then select a destination. The only destinations that will appear in the drop down selection box will be those defined as belonging to the Caribbean. |
Tables | |
Common Tables: |
|
Continent: | for a geographic area larger than any single Country. |
Country: | Specific to a single Country. |
Region: | Geographical area smaller than a single Country but larger than a single City. |
City: | Specific to a single City. |
Resort: | Geographical area usually smaller than a single City. |
Airport: | Specific to a single Airport |
Carrier: | Name of the carrier, Air, Sea or Ground. e.g. British Airways, Excel Airways |
Class: | Scheduled Economy, Charter Economy etc |
Board: | Standard Codes for accommodation meal plans |
You will have to advise on the function of changing codes incase a client has a specific search based on a code and that code subsequently changes whether it is an Airport, City, Region, Country or any other code. As in the example, someone searching for a Caribbean holiday would see only Countries where Continent Code in the Country table matched the Continent Code in the Continent Code for the Caribbean in the Continent table. |
|
For somewhere like Jamaica, then would be a number of holiday options around the Island such as Montego Bay, Negril, Ocho Rios. By introducing a Region table, we have the ability to define where specific hotels are located rather than just using an Airport or City Code. Results can be categorized by Region if required so browsers could see all the Montego Bay properties together, then all the Negril properties and so on. If no Region Code was defined for an accommodation then the City/Airport Code would be used. For destinations such as Antigua and Barbados, these are generally just displayed altogether. Holidays.asp should therefore have a setting for how to display results. If a user selected Caribbean holidays then Jamaica then the variables could be like the example below. Dates fields not included. mytravelcompany.co.uk/holidays.asp?Country=JM would say display results for Jamaica but, mytravelcompany.co.uk/holidays.asp?Country=JM?Display=BreakdownByRegion could be used to to instruct the page to display by Region (or City if no Region Code set at accommodation level). How to affect display may well not be defined by using variables on the asp page but it's to give an idea. If it's too much resource then we could just display results in the default order and show the Region as text if this has been set at the accommodation level. |
|
In the table descriptions, we are not going to define every possible field and code them, this is to give you a good flavor of what is required for the project only. |
Tables | |
User Specific Tables: |
|
Flight: | |
Accommodation: | |
Currency: | |
Region: Geographical area smaller than a single Country but larger than a single City. | |
City: Specific to a single City. | |
Airport: Specific to a single Airport | |
As in the example, someone searching for a Caribbean holiday would see only Countries where Continent Code in the Country table matched the Continent Code in the Continent Code for the Caribbean in the Continent table. | |
For somewhere like Jamaica, then would be a number of holiday options around the Island such as Montego Bay, Negril, Ocho Rios. By introducing a Region table, we have the ability to define where specific hotels are located rather than just using an Airport or City Code. Results can be categorized by Region if required so browsers could see all the Montego Bay properties together, then all the Negril properties and so on. | |
In the table descriptions, we are not going to define every possible field and code them, this is to give you a good flavor of what is required for the project only. |