Saved searches

Use saved searches to filter your results more quickly

You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session.

Database system to manage destinations, flights, hotels and itineraries.

Notifications You must be signed in to change notification settings

hokocodes/SQL-Travel-Planner-System

This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.

Folders and files

Latest commit

History

Repository files navigation

Travel Planner System

Welcome to the Travel Planner System repository! This project is a simple and efficient system for managing travel itineraries, destinations, flights, and hotels using SQL.

Table of Contents

Overview

The Travel Planner System is designed to help users plan their trips by providing a centralized database for managing travel-related information. It includes tables for destinations, flights, hotels, and itineraries, allowing users to create and organize their travel plans seamlessly.

Features

• Add and manage destinations with details like name, country, and description.
• Store flight information, including airline, departure/arrival cities, dates, and prices.
• Manage hotel details, such as hotel name, location, check-in/out dates, and pricing.
• Create travel itineraries by combining destinations, flights, and hotels.
• Perform various queries to retrieve information about travel plans.

Database Schema

The system follows a relational database schema with the following tables:

• Destinations
• Flights
• Hotels
• Itineraries

For more details, refer to the Database Schema section.