Hotel Room Booking System (Entity-Relationship Diagram)

Example of entity-relationship diagram for a hotel room booking system.

ER Diagram for Hotel Room Booking System

The ER diagram depicts entities in the hotel room booking system. A room may be booked by a guest for a given period. Each room has its type and photos.

Hotel Room Booking System (Entity-Relationship Diagram)
Hotel Room Booking System (Entity-Relationship Diagram)

This ER model for a hotel reservation system describes the following entities (and relationship between them):

  • Room
  • Room Type
  • Room Photo
  • Photo
  • Room Booking
  • Guest Room Booking
  • Guest

Download Entity-Relationship Diagram for Booking System

Hotel Room Booking System (Entity-Relationship Diagram)


Mateti Varun 27 July 2019 8:33:43


For booking a room in a hotel.

Smangele 6 November 2019 10:51:15

Software Engineering

This site is a great help..

Dusan Rodina - 7 November 2019 8:09:28

RE: Software Engineering

Thank you.

margaretta da silva 15 December 2021 1:42:40

Tour & Travel Management

Thank you for share this site

Kidus 15 July 2023 14:11:53


I want ER diagram and tables

New Comment