A comprehensive SQL-based database system designed to streamline travel agency operations by centralizing bookings, customers, tour packages, and vendor data into a single, efficient platform.
This project focuses on building a normalized relational database (1NF → 3NF) to replace fragmented systems such as Excel sheets, manual booking records, and disconnected vendor files.
💡 Objective: Enable data-driven tourism operations by improving efficiency, accuracy, and decision-making.
| Role | Name | Specialization |
|---|---|---|
| Created By | Sonal Shelke | Data Analytics |
| Academic Mentor | Shalini Verma | Mentor |
- Eliminate manual and disconnected systems
- Develop a centralized SQL-based RDBMS
- Improve operational efficiency and accuracy
- Enable data-driven decision-making
The system is built on a fully normalized SQL schema covering all major functional areas of a travel business.
| Domain | Key Data Managed |
|---|---|
| Tour Packages | Destinations, pricing, itineraries |
| Bookings | Customer bookings, payments, cancellations |
| Travel Operations | Hotels, transport services, vendors, guides |
| Marketing & Engagement | Leads, customer feedback, travel history |
- Bookings ↔ Payments → Ensures accurate transaction tracking
- Packages ↔ Operations → Aligns availability with vendors
- Customer Data ↔ Feedback → Enables personalized recommendations
- Complex SQL JOIN queries across multiple tables
- Enables personalized recommendations and targeted offers
- Views, Stored Procedures, Triggers
- Automates booking workflows and reporting
- Transaction Control (START TRANSACTION, COMMIT, ROLLBACK)
- Prevents incomplete or inconsistent transactions
- Window Functions (RANK, PARTITION BY, OVER)
- Identifies top-performing packages and seasonal trends
- Access Control (GRANT, REVOKE)
- Protects sensitive customer and payment data
- Normalized schema with indexing
- Faster queries and optimized performance
- MySQL / MariaDB / PostgreSQL
- MySQL Workbench or any SQL client
- DDL, DML, DQL
- Views
- Stored Procedures & Triggers
- User-Defined Functions (UDFs)
- Window Functions
- Transaction Control (TCL)
- Data Control (DCL)
- Database Normalization (1NF → 3NF)
- ✅ 100% centralized data management
- ✅ Reduced manual effort through automation
- ✅ Faster and more accurate booking processes
- ✅ Improved decision-making with real-time insights
- Build interactive dashboards for real-time insights
- Perform customer segmentation and cohort analysis
- Forecast travel demand using predictive analytics
- Develop data-driven recommendation systems
- Create KPI dashboards using Power BI / Tableau
- Design ETL pipelines for scalable analytics
- MySQL Server (8.0 or later recommended)
- MySQL Workbench or any SQL client
Contributions are welcome! Feel free to fork the repository and submit a pull request.
Sonal Shelke