Travel Agency Management System ER Diagram

Posted By freeproject on July 17, 2017

This ER (Entity Relationship) Diagram represents the model of Travel Agency Management System Entity. The entity-relationship diagram of Travel Agency Management System shows all the visual instrument of database tables and the relations between Customer, Bookings, Travel Agency, Payments etc. It used structure data and to define the relationships between structured data groups of Travel Agency Management System functionalities. The main entities of the Travel Agency Management System are Travel Agency, Customer, Cabs, Bookings, Hotels and Payments.

Travel Agency Management System entities and their attributes :

  • Travel Agency Entity : Attributes of Travel Agency are agency_id, agency_name, comapny_type, agency_description, agency_address
  • Customer Entity : Attributes of Customer are customer_id, customer_name, customer_mobile, customer_email, customer_username, customer_password, customer_address
  • Cabs Entity : Attributes of Cabs are cab_id, cab_name, cab_type, cab_description
  • Bookings Entity : Attributes of Bookings are booking_id, booking_hotel_id, booking_title, booking_type, booking_date, booking_description
  • Hotels Entity : Attributes of Hotels are hotel_id, hotel_name, hotel_type, hotel_rent, hotel_description, hotel_address
  • Payments Entity : Attributes of Payments are payment_id, payment_customer_id, payment_date, payment_amount, payment_description

Description of Travel Agency Management System Database :

  • The details of Travel Agency is store into the Travel Agency tables respective with all tables
  • Each entity ( Payments, Cabs, Hotels, Customer, Travel Agency) contains primary key and unique keys.
  • The entity Cabs, Hotels has binded with Travel Agency, Customer entities with foreign key
  • There is one-to-one and one-to-many relationships available between Hotels, Bookings, Payments, Travel Agency
  • All the entities Travel Agency, Hotels, Cabs, Payments are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Travel Agency Management System tables for fast query execution.
Travel Agency Management System ER Diagram
Get 6 diagrams only in 300/- or $6.99 USD.
Call or WhatsApp us on +91-8470010001 for more details.

Project Category

Related Entity Relationship Diagram (ERD)

Music Library Management System ER Diagram

Music Library Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Music Library Management System Entity. The entity-relationship diagram of Music Library Management System shows all the visual instrument of database tables and the relations between Album, Track, Music, Singer etc. It used structure...
Internet Cafe ER Diagram

Internet Cafe ER Diagram

This ER (Entity Relationship) Diagram represents the model of Internet Cafe Entity. The entity-relationship diagram of Internet Cafe shows all the visual instrument of database tables and the relations between Internet, Bills, Users, Login etc. It used structure data and to define the relationships...
Classifieds Management System ER Diagram

Classifieds Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Classifieds Management System Entity. The entity-relationship diagram of Classifieds Management System shows all the visual instrument of database tables and the relations between Location, Categories, Advertisement, Listing etc. It used...
Hall Booking System ER Diagram

Hall Booking System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Hall Booking System Entity. The entity-relationship diagram of Hall Booking System shows all the visual instrument of database tables and the relations between Booking, Customers, Hall, Bill etc. It used structure data and to define the...
Faculty Management System ER Diagram

Faculty Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Faculty Management System Entity. The entity-relationship diagram of Faculty Management System shows all the visual instrument of database tables and the relations between Faculty, Teacher, Leave, Subject etc. It used structure data and...
Car Insurance Management System ER Diagram

Car Insurance Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Car Insurance Management System Entity. The entity-relationship diagram of Car Insurance Management System shows all the visual instrument of database tables and the relations between Insurance, Booking, Car, Bill etc. It used structure...
HRD Management System ER Diagram

HRD Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of HRD Management System Entity. The entity-relationship diagram of HRD Management System shows all the visual instrument of database tables and the relations between Trainings, Departments, Employee, Salary slip etc. It used structure data...
Vehicle RTO Registration System ER Diagram

Vehicle RTO Registration System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Vehicl RTO Registration System Entity. The entity-relationship diagram of Vehicl RTO Registration System shows all the visual instrument of database tables and the relations between Registration, Vehicle Maker, Vehicle, Driving License...
Employee Management System ER Diagram

Employee Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Employee Management System Entity. The entity-relationship diagram of Employee Management System shows all the visual instrument of database tables and the relations between Salary, Experience, Employee, Attendance etc. It used structure...
Library Application System ER Diagram

Library Application System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Library Application System Entity. The entity-relationship diagram of Library Application System shows all the visual instrument of database tables and the relations between Book, Address, Student, Supplier etc. It used structure data...