In this article, we will cover how to create a hotel reservation system ER diagram.
This ER diagram for the Online Hotel Reservation System is the project design that displays hotel reservation entities.
Furthermore, this describes the logical structure of the system’s database or data storage.
It is done by identifying the online hotel reservation process entities, their properties, and the interactions between them.
The database design is outlined using online hotel reservation system project ER diagrams.
This database design becomes the actual basis of the system’s data storage that will serve as the data destination and source.
Online Hotel Reservation System ER Diagram: Details
The table shows the overall description of the ER diagram of the Online Hotel Reservation system. It has a complete overview of project details.
| Name: | Online Hotel Reservation System ER Diagram |
| Abstract: | The online hotel reservation system ER diagram defines 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. |
| Designer: | Sourcecodehero.com |
What is an Online Hotel Reservation System?
A hotel reservation system is a piece of software that allows clients to book directly with the hotel online, bypassing the need for middlemen.
It enables guests to design their own vacation at their leisure.
It’s a software application that shows your live pricing and inventory across all of your channels in real time, allowing guests to choose their travel dates and complete their reservations.
What is an ER Diagram?
The ER Diagram also refers to the database design of the online hotel reservation system. It is the graphical representation of the relationships between all system entities. It consists mostly of Entities, Attributes, and Relationships.
Importance of ER Diagram
In addition, the ER diagram describes entity relationships with other entities. ER diagrams are utilized for all other real-world tasks.
In relation to its data flow diagram, the ER diagram for the online hotel reservation system is used to display the details and attributes of the data.
They are essential for constructing a relational database because they let us visualize how data is generically associated.
(ER) Diagram for Hotel Reservation System
The ER Diagram of the Hotel Reservation System shows the included entities (data) and their supposed functions (attributes). Each of them was represented by a table to illustrate their characteristics and relationships with each other.
The figure above shows the whole purpose of the database design of the ER Diagram for the Online Hotel Reservation system.
Furthermore, it demonstrates the existence of a database to store all system data and provide user output.
Hotel Reservation System ER Diagram Tables
The tables below provide the complete database table details such as Field Name, Descriptions, data types, and character lengths.
Afterward, each of these tables represents the characteristics and the attributes of data storage.
Table Name: Accounts
| Field | Description | Type | Length |
| account_ID (PK) | Account ID | Int | 11 |
| type | Account Type | Varchar | 255 |
| username | Username | Varchar | 255 |
| password | Password | Varchar | 255 |
Table Name: Customer
| Field | Description | Type | Length |
| cust_ID (PK) | Customer ID | Int | 11 |
| account_ID (FK) | Account ID | Int | 11 |
| name | Customer Name | Varchar | 255 |
| age | Customer Age | Varchar | 255 |
| gender | Customer Gender | Varchar | 255 |
| contact_number | Contact Numer | Varchar | 255 |
| address | Customer Address | Text | 11 |
Table Name: Crew
| Field | Description | Type | Length |
| crew_ID (PK) | Crew ID | Int | 11 |
| account_ID (FK) | Account ID | Int | 11 |
| name | Crew Name | Varchar | 255 |
| job_title | Job Title | Varchar | 255 |
| assignment | Work Assignment | Varchar | 255 |
| details | Assignment Details | Text |
Table Name: Reservation
| Field | Description | Type | Length |
| reservation_ID (PK) | Reservation ID | Int | 11 |
| crew_ID (FK) | Crew ID (FK) | Int | 11 |
| cust_ID (FK) | Customer ID | Int | 11 |
| room_ID (FK) | Room ID | Int | 11 |
| date | Date of Reservation | Date | |
| date_in | Date of Coming In | Date | |
| date_out | Date of Coming Out | Date | |
| total_payment | Total Payment | Varchar | 255 |
Table Name: Room Type
| Field | Description | Type | Length |
| type_ID (PK) | Room Type ID | Int | 11 |
| name | Room Name | Varchar | 255 |
| description | Description | Text |
Table Name: Rooms
| Field | Description | Type | Length |
| room_ID (PK) | Room Class ID | Int | 11 |
| type_ID | Room Name | Varchar | 30 |
| price | Room Price | Int | 11 |
Table Name: Payment
| Field | Description | Type | Length |
| payment_ID (PK) | Payment ID | Int | 11 |
| cust_ID (FK) | Customer ID | Int | 11 |
| method | Payment Method | Varchar | 255 |
| date | Date of Payment | Date |
Table Name: Transaction
| Field | Description | Type | Length |
| trans_ID (PK) | Transaction ID | Int | 11 |
| tran_date | Transaction Name | Date | |
| cust_ID (FK) | Customer ID | Int | 11 |
| crew_ID (FK) | Employee ID | Int | 11 |
| pay_ID (FK) | Payment ID | Int | 11 |
| reservation_ID (FK) | Reservation ID | Int | 11 |
The tables given will be the basis for developers on how would they would work on the order management system database design.
It has the complete description of the database and will be applied to the program as data storage the same as the names given to each of the tables.
Hotel Manageent System ER Diagram [PDF]
The concepts of the database for the project are explained in a PDF document. You may apply this information to your capstone project.
You can also utilize it directly or edit its content based on the needs of your project.
How to create ER Diagram
Time needed: 5 minutes
Steps in building the ER Diagram for Hotel Reservation System with Cardinality Ratio.
- Step 1: Familiarize the ER Diagram (Entity Relationship Diagram) Symbols and Cardinality
The Entity Relationship Diagram is the structure of the data types in a project. It uses symbols to clarify the relationships of each entity.
Their symbols and applications must be familiarized before you build the ER Diagram.
ER Diagram Symbols:
• Fields: Fields are the parts of a table that define the entity’s characteristics. In the database that the ERD models, attributes are commonly thought of as rows.
• Keys is a technique to categorize data qualities. It is used to organize ER diagrams and assist users in modeling their databases to ensure that they are efficient. This is also used to connect different tables in a database.
– Primary Key: identifies a single entity instance which means a unique attribute or set of attributes.
– Foreign Key: is produced when data attributes have one too many relationships with other entities. - Step 2: Finalize the entities included
Initiate the creation of your ER Diagram by determining which entities must be included in your bank reservation system. This entity is represented by a rectangle, and you should leave ample space in your design for their addition in subsequent phases.
- Step 3: Add the attributes of each entity
After finalizing the entities, consider the characteristics that will define each one. As characteristics, a conceptual ER diagram specifies the particulars of the many things depicted. Attributes include characteristics of an entity, a many-to-many relationship, and a one-to-one relationship. Multiple values can be assigned to multivalued properties.
- Step 4: Describe the relationships (cardinality) between entities and attributes
Entities, their properties, and relationships are required to depict the relationships between the ERD. To create an exact Entity Relationship Diagram, you will base the data structure on the evaluated information.
Conclusion
In summary, the ER diagram for the Hotel Reservation System helps to create a fully functional system. Other than that it will help you in conceptualizing the backend of the software.
Finally, the ER diagram holds all the data that enter and exit the system.
Also, You may visit the link below for more information about diagrams.
- ER Diagram of Hotel Management System
- Sequence Diagram of Hotel Reservation System
- Activity Diagram for Hotel Room Booking
- Hotel Management System DFD
- Airline Reservation System Use Case Diagram
- Hotel Management System Use Case Diagram
If you have inquiries or suggestions just leave us your comments below. We would be glad to know to concerns and suggestions and be part of your learning.
Keep us updated, and have a Good Day!