This ER diagram illustrates a Travel Management System involving Customers, Bookings, Destinations, Hotels, and Flights. Customers make bookings, each associated with a destination. Destinations have hotels and flights linked to them. The relationships between these entities demonstrate how customers make bookings for destinations, and how destinations are connected to hotels and flights, facilitating travel arrangements.
Travel management system diagram code in Gleek
Customers
Integer customerId PK "Unique Identifier for the customer"
String customerName "Name of the customer"
String customerEmail "Email of the customer"
String customerPhone "Phone number of the customer"
Bookings
Integer bookingId PK "Unique Identifier for the booking"
Date bookingDate "Date of the booking"
String bookingStatus "Status of the booking"
Destinations
Integer destinationId PK "Unique Identifier for the destination"
String destinationName "Name of the destination"
String destinationDescription "Description of the destination"
Hotels
Integer hotelId PK "Unique Identifier for the hotel"
String hotelName "Name of the hotel"
String hotelAddress "Address of the hotel"
Integer hotelRating "Rating of the hotel"
Flights
Integer flightId PK "Unique Identifier for the flight"
String flightNumber "Number of the flight"
Date flightDeparture "Departure date of the flight"
Date flightArrival "Arrival date of the flight"
Customers {1}-makes-{1..n} Bookings
Bookings {1}-for-{1..n} Destinations
Destinations {1}-has-{1..n} Hotels
Destinations {1}-has-{1..n} Flights
About ER diagrams
We often make an entity-relationship (ER) diagram, ERD, or entity-relationship model, in the early stages of designing a database. An ERD is perfect for quickly sketching out the elements needed in the system. The ERD explains how the elements interact. ER diagrams can be shared with colleagues. Their simplicity makes them ideal even for non-technical stakeholders.
Similar ER diagram examples
Online store entity-relationship diagram
Simple ER diagram example with Chen notation
Employee management system entity-relationship diagram
Banking system entity-relationship diagram
College management system ER diagram
Online shopping entity-relationship diagram
Student management system entity-relationship diagram
Library management system ER diagram with Chen notation