The Tourism Management System is a database-centric project designed to simulate real-world data operations in the tourism industry. It supports core operations for managing tour packages, customers, bookings, and payments using a relational database (PostgreSQL). This project showcases entity relationships, normalization, and SQL-based operations essential for backend data management in travel agencies or tour platforms.
🏝️ Tour Package Management – Add, update, and query tour details.
👤 Customer Information Management – Maintain personal and contact details.
📅 Booking System – Manage bookings linked to tours and customers.
💰 Payments & Transactions – Track transactions, payment status, and revenue.
📝 Feedback Mechanism – Record and analyze customer feedback.
-
Install PostgreSQL.
-
Create the database:
CREATE DATABASE tourism_db; USE tourism_db;
-
Run the following script:
T209_Database_Seeding.sql
-
Test queries from
T209_Queries.pdf.
- Retrieve all bookings for a specific customer
- List most popular tour packages
- Get total revenue by month
- Find customers who never gave feedback
- All tables follow Boyce Codd Normal Form (BCNF)
- Redundancy minimized using foreign keys
Available in the file T209_ERD.pdf for better understanding of entity relationships.
This project is a submission for a Database Management Systems (DBMS) course. It demonstrates:
- Relational schema design
- Querying with SQL
- Data integrity via constraints
- Add stored procedures and triggers
- Integrate with a frontend using Flask or React
- Implement report generation (PDF/CSV exports)
- Apply real-world constraints (e.g., max group size, date validations)
- Sahil Sutariya – 202201119
- Meet Andharia – 202201145
- Dev Dodiya – 202201153
- Malhar Vaghasiya – 202201183
- Akshat Joshi – 202201185