Database For Searching Pet Friendly Airline

Problem

Now many people are keen to bring their pets when flying, but due to different airline regulations, finding the right airline according to their pet needs is a very important issue. Especially for those who are used to ordering air tickets on travel agency websites, they urgently need a database to find the product they want.

Solution

In this document I am going to explain how we could use database in a travel agency in order to help the pet owner to find the appropriate flight with in the catagory of pet and the relevant regulaton such as hold, cable, medical certification...

Here an example of the database of a Travel Agency

Here an example of code to add some datas regarding airline in our database

Example

Some passengers have more expensive pets and need to fly with the pet owner instead of freight. Customers need to know which airlines can accept pets into the cabin. So if there is a database to filter, customers can easily know the range of airlines they can choose.

Here is the example of selecting the airline accept pet in cabin