🧳 Travel & Tour Management System — Database Project

A fully structured Travel & Tour Management System created as a DBMS academic project. This system includes ERD, normalized tables, SQL queries, sample data, and complete database documentation for managing customers, tour packages, bookings, and payments.

---

📌 Overview

This database project is designed to handle the core operations of a travel agency, ensuring data consistency, smooth retrieval, and well-defined relationships between tables.

---

🎯 Features

• Customer registration & management
• Tour package management (CRUD)
• Booking creation & tracking
• Payment records with invoice system
• Admin control for managing all modules
• Normalized database (1NF, 2NF, 3NF)

---

🗂️ Database Design

✔️ Tables Included

• Customers
• Packages
• Bookings
• Payments
• Admin (optional)

✔️ ERD (Entity Relationship Diagram)

• One Customer → Many Bookings
• One Package → Many Bookings
• One Booking → One Payment

✔️ Keys

• Primary keys on each table
• Foreign keys connecting bookings to customers & packages
• Payment linked with booking ID

---

💾 SQL Queries Included

• Insert / Update / Delete (CRUD)
• Customer booking history
• Package list & search
• Payment status check
• Monthly booking report
• Revenue report

---

🛠️ Tools Used

• MySQL
• MySQL Workbench / phpMyAdmin
• (Optional) PHP, HTML/CSS
• Git & GitHub

---

📂 Folder Structure

/Travel_Tour_DB_Project
│── ERD/
│── SQL_Scripts/
│── Tables/
│── Sample_Data/
│── Screenshots/
│── README.md

---

🚀 How to Use

1. Clone or download the repository
2. Import the SQL file into MySQL
3. View tables & ERD
4. Run queries
5. Connect to frontend/backend if required

---

📢 Future Enhancements

• Online booking website
• Authentication system
• Email confirmation for bookings
• Payment gateway integration