Features:
- Adding New Routes: Handles the addition of new air routes between airports in different cities, with full safeguards against errors such as intra-city routes.
- Airport Codes: Supports original airport codes, considering IATA and ICAO codes.
- Operators and Promotions: Handles airline operators for adding promotions, taking into account their original headquarters.
- Route Creation: Capable of creating routes with specified flights, route IDs, dates, times, and handling basic flight costs. Supports original flight codes.
- Ticket Purchasing: Feature for purchasing tickets, including customer data and available promotions.
- Travel Table: Creating and managing a travel table, including an algorithm for automatic creation of journeys and connections.
- Dependency Diagram: A diagram showing the relationships between individual tables.
- Search Algorithms: Advanced airport and route search algorithms, including checking if a plane is not heading to the same city and airport.
- Promotional Codes: Algorithm for generating promotional codes for travel agencies.
- Error Handling: Advanced error handling, including GeoBlock errors (403) and basic errors like a missing table (in which case the script automatically creates the missing table, protecting the database system from failure).
- Ticket Purchase Algorithm: An advanced ticket purchasing system, taking into account customer data and available promotions.
- Handling Multiple Promotions: Ability to handle multiple promotions for various routes simultaneously.
- Safeguards: Handling errors related to server overload, especially when many people are trying to purchase tickets at the same time.
Used skills
- SQL database management and query optimization.
- Development of advanced search and route generation algorithms.
- Integration and handling of IATA and ICAO airport codes.
- Error handling and recovery mechanisms.
- Creation and management of relational database tables and diagrams.
- Implementation of promotional algorithms and handling of multiple promotions.
- Design and development of user interfaces for ticket purchasing.
- Server load management and error prevention techniques.