ER Diagram for Hotel Management System

ER diagram for hotel management system in DBMS illustrates how database elements are related. This shows how the system’s database or data storage is put together logically. It is done by figuring out the parts of the hotel management process, their properties, and how they work together.

Draw an ER diagram for hotel management system are used to draw out the design of the database. This database sketch becomes the system’s data storage, where data goes and comes from.

Hotel Management System ER Diagram: Details

The table shows the overall description of the ER Diagram Hotel Management System in DBMS. It has a complete overview of the project’s information.

Name:Hotel Management System ER Diagram
Abstract:The hotel management system ER diagram depicts the relationship between various entities. It can be thought of as a blueprint for your system (project) structure. 
Diagram:ER Diagram is also known as Entity Relationship Diagram
Tools Used:Diagraming tools that provide ER diagram symbols.
Users:Website, Applications, and Software.
Hotel Management System ER Diagram: Details

What is Hotel Management System?

The hotel management software is a set of hotel management apps that keep things running smoothly. Accounting software, customer relationship management software, and a huge number of industry-specific programs are all available.

What is an ER Diagram?

The ER Diagram is also known as the database design for the hotel management system project. This ER diagram is a picture of how all the entities in the system are related to each other. Entities, Attributes, and Relationships are its most important parts.

Importance of ER Diagram

Simple ER diagram for hotel management system data storage or database. It is the foundation for building the project’s database foundation. This entity-relationship diagram (ERD) defines data types, attributes, and properties.

Entity-Relationship (ER) Diagram for Hotel Management System

The Hotel Management System’s ER Diagram shows system entities (data) and their roles (attributes). Each of them was represented by a table that showed what they were like and how they related to each other.

ER Diagram Hotel Management System Project (Database Design)

Hotel Management System ER Diagram
Hotel Management System ER Diagram

The example shows the Hotel Management System ER Diagram database design. This shows that all system data and user outputs are saved in a database. A Hotel Management System in DBMS needs a good database or ER Diagram design.

Hotel Management System ER Diagram Tables

The tables below list each database table’s field name, description, data type, and character length. Each table defines and explains data storage.

The field column lists database attributes, whereas the description column describes each. Type shows what kind of data each attribute is, and length displays how many characters it has.

Table Name: tblCustomer

cust_ID (PK)Customer IDInt11
custfnameCustomer First NameVarchar255
custlnameCustomer Last NameVarchar255
reservationCustomer ReservationVarchar255
addressCustomer AddressVarchar255
statusCustomer StatusVarchar255
contact_addressContact AddressInt11
Table Name: tblCustomer

Table Name: tblRoom

room_ID (PK)Room IDInt11
room_typeRoom TypeVarchar30
room_sampleRoom SampleVarchar30
descriptionRoom DescriptionText
Table Name: tblRoom

Table Name: tblReservation

reservation_ID (PK)Reservation IDInt11
customer_ID (FK)Customer IDInt11
room_ID (FK)Room IDInt11
reservation_dateDate of ReservationDate
date_inDate of Coming InDate
date_outDate of Coming OutDate
days_rangeRange of DaysInt11
Table Name: tblReservation

Table Name: tblRoomClass

class_ID (PK)Room Class IDInt11
nameRoom NameVarchar30
priceRoom PriceInt11
Table Name: tblRoomClass

Table Name: tblPayment

payment_ID (PK)Payment IDInt11
customer_ID (FK)Customer IdInt11
typePayment TypeVarchar30
payment_dateDate of PaymentDate
Table Name: tblPayment

Table Name: tblEmployees

employee_ID (PK)Employee IdInt11
fnameFirst NameVarchar30
lnameLast NameVarchar30
job_departmentJob DepartmentVarchar30
contact_addressContact AddressInt11
Table Name: tblEmployees

Table Name: tblTransactions

transaction_ID (PK)Transaction IDInt11
transaction_nameTransaction NameVarchar30
customer_ID (FK)Customer IDInt11
employee_ID (FK)Employee IDInt11
reservation_ID (FK) Reservation IDInt11
transaction_date Transaction DateDate
Table Name: tblTransactions

Table Name: tblReports

report_ID (PK)Report IDInt11
transaction_ID (FK)Transaction IDInt11
nameReport nameVarchar30
typeReport TypeVarchar30
Table Name: tblReports

The tables will help developers set up the hotel management system’s database. It offers a full description of the database along with table names. They’ll enter attributes and values into a database.

Hotel Management System ERD [PDF]

The information about how the project database works is in the ER Diagram for Hotel Management System PDF. This information can help you with your capstone project. You can also use it as is or change its content to fit the needs of your project.

How to create ER Diagram

Time needed: 5 minutes.

Steps in building the ER Diagram for Hotel Management System with Cardinality Ratio.

  • Step 1: Familiarize the ER Diagram (Entity Relationship Diagram) Symbols and Cardinality

    The project’s data structure is shown in the Entity Relationship Diagram. Symbols show how its parts fit together. Before making an ER Diagram, you should know what its symbols mean and how to use them.

    ER Diagram Symbols:
    Fields: The Entity Relationship Diagram shows how the different types of data in a project are put together. It uses symbols to show how its parts work together. Before making the ER Diagram, you need to know what their symbols mean and how to use them.

    Keys is a technique to categorize data quality. 

    – Primary keys are unique attributes or sets of properties used to find a particular entity. 
    – A “Foreign Key” is made when a piece of data has too many links to other things.

  • Step 2: Finalize the entities included

    Start making your ER Diagram by deciding on all the parts your blood bank management system must have. You’ll need to leave area in your design for these rectangles to be included later.

  • Step 3: Add the attributes of each entity

    After you’ve decided on the entities, think about the traits you’ll need for each one. In a conceptual ER diagram, the details of the different entities are given as attributes. Attributes are things like a thing’s traits, a many-to-many relationship, or a one-to-one relationship. Attributes with multiple values can be given more than one value.

  • Step 4: Describe the relationships (cardinality) between entities and attributes

    You will need the entities, their attributes, and the relationships between them in order to plot the relationships between the ERD. To get the right entity relationship diagram, you will use the information you gathered to build the data structure.


You need to know how the Hotel Management System was designed and built using diagrams. With the help of an ER diagram, that will help you make a system that works well.

Making it will help you understand how the software works behind the scenes. This is where all the data that goes in and out of the system will be stored.


Leave us a comment below if you have questions or ideas about the ER Diagram for Hotel Management System. We would love to hear about your worries and ideas and help you learn.

Leave a Comment