Welcome to the Travel Agency Database! This project is designed to facilitate travel management processes for a travel agency, providing comprehensive tools for planning, booking, and monitoring trips.
- General info
- Technologies
- ER Diagram
- Functional requirements
- Non-functional requirements
- Content Overview
- Additional info
- Planned changes
- Author
The "Travel Agency" database is a key tool in organizing customer travel by a travel agency. It provides comprehensive data management necessary for planning, booking and monitoring trips.
- Add, edit, and delete continents, countries, cities, bus routes, flights, hotels, and travel packages.
- View information about available routes, flights, hotels, and travel packages.
- Search for travel packages based on various criteria such as country, continent, city, and price.
- Automatically calculate and update package details (start date, end date, duration, price) based on associated hotel, flight, and bus route data.
- Allow customers to book travel packages.
- Enable customers to view their reservations and transaction history.
- Allow travel agency employees to manage reservations (add, edit, delete).
- Calculate and update reservation prices for specific packages based on provided percentage discounts.
- Enable system administrators to manage users, assign roles, and enforce access permissions.
- Generate revenue reports based on travel package bookings.
- Generate popularity reports showing booking frequency for each package.
- Generate detailed booking reports for analysis.
- Ensure the system is responsive with minimal response times, even when handling large datasets.
- Store customer personal data securely in compliance with data protection regulations.
- Implement user authentication and authorization mechanisms to control data access.
- Maintain system availability with minimal downtime, including regular data backups for disaster recovery.
- Design the system to scale efficiently as the user base and data volume grow.
- Create an intuitive and user-friendly interface adaptable to various devices.
- Maintain up-to-date system documentation including functional descriptions, operating instructions, and maintenance procedures.
The database contains information about customers, including personal data, contacts and addresses, which facilitates identification and communication. Additionally, data on continents, countries and cities enable you to choose the right travel destination.
Information about hotels, flights, guides, drivers and buses is crucial to putting together comprehensive travel packages. They allow you to choose the best accommodation options, flight routes and transport between destinations.
Travel bookings are tracked in a separate table, making it easy to manage them and monitor your customers' travel history. This allows the agency to tailor its offer to customer preferences, ensuring high quality of services and customer satisfaction, which in turn translates into an increase in income.
This project is not commercial. The main goal of "Travel Agency Database" is to learn
- Developing, implementing and programming a server-side database in an environment MS SQL Server
- Development of design documentation
This project is at the development stage and has not been completed. I am planning to
Add an archive table- Add system users divided into users, administrator, office employee, etc., assigning appropriate permissions
- Expanding tbl_hotel table to include hotel availability, different room types.
Expanding tbl_package table to include places available for reservation- Add additional attractions in the city travel
Add additional procedures and functions for greater database functionality (automatically "deleting" (archiving) outdated records )- Create a dekstop application after searching for travel using the presented database
Maryia Shyliankova
Last update: 10/05/2024