CloudSketch AI Logo
FeaturesTemplatesPricingEnterpriseAboutContactLog in
🌙☀️
Log inStart free
Home/Templates/Student Projects (College Reports)

🎓 Student Projects (College Reports) · Database ERD

Hotel Room Booking System ER Diagram

Database for hotel bookings: room types, rooms, guests, bookings, payments and stays.

More Student Projects (College Reports) templates

Opening a template is free and never counts toward your daily diagrams. Asking the AI to change it counts as one.

Drawing diagram…

What this diagram shows

  • Room type holds the rate; rooms belong to a type
  • Booking can cover several rooms through BookingRoom
  • Payments and invoices tied to the booking

Prompt used

ER diagram for a hotel room booking system: RoomType (name, rate, capacity), Room (number, floor, status, belongs to a room type), Guest, Booking (check-in and check-out dates, status, made by a guest), BookingRoom linking bookings to rooms, Payment for a booking, and Invoice generated at check-out.

Mermaid code
erDiagram
  ROOM_TYPE ||--o{ ROOM : groups
  GUEST ||--o{ BOOKING : makes
  BOOKING ||--|{ BOOKING_ROOM : includes
  ROOM ||--o{ BOOKING_ROOM : "reserved in"
  BOOKING ||--o{ PAYMENT : "paid by"
  BOOKING ||--o| INVOICE : "billed in"
  ROOM_TYPE {
    int type_id PK
    string name
    decimal rate
    int capacity
  }
  ROOM {
    int room_no PK
    int type_id FK
    int floor
    string status
  }
  GUEST {
    int guest_id PK
    string name
    string phone
    string email
  }
  BOOKING {
    int booking_id PK
    int guest_id FK
    date check_in
    date check_out
    string status
  }
  BOOKING_ROOM {
    int booking_id FK
    int room_no FK
  }
  PAYMENT {
    int payment_id PK
    int booking_id FK
    decimal amount
    string method
  }
  INVOICE {
    int invoice_id PK
    int booking_id FK
    decimal total
    date issued_on
  }

Inside this diagram

An entity relationship diagram with 7 tables, 27 columns and 6 relationships.

Tables and their columns

  • ROOM_TYPE: type_id (PK), name, rate, capacity
  • ROOM: room_no (PK), type_id (FK), floor, status
  • GUEST: guest_id (PK), name, phone, email
  • BOOKING: booking_id (PK), guest_id (FK), check_in, check_out, status
  • BOOKING_ROOM: booking_id (FK), room_no (FK)
  • PAYMENT: payment_id (PK), booking_id (FK), amount, method
  • INVOICE: invoice_id (PK), booking_id (FK), total, issued_on

Relationships

  • ROOM_TYPE groups ROOM: each ROOM_TYPE has zero or more ROOM, each ROOM belongs to exactly one ROOM_TYPE
  • GUEST makes BOOKING: each GUEST has zero or more BOOKING, each BOOKING belongs to exactly one GUEST
  • BOOKING includes BOOKING_ROOM: each BOOKING has one or more BOOKING_ROOM, each BOOKING_ROOM belongs to exactly one BOOKING
  • ROOM reserved in BOOKING_ROOM: each ROOM has zero or more BOOKING_ROOM, each BOOKING_ROOM belongs to exactly one ROOM
  • BOOKING paid by PAYMENT: each BOOKING has zero or more PAYMENT, each PAYMENT belongs to exactly one BOOKING
  • BOOKING billed in INVOICE: each BOOKING has zero or one INVOICE, each INVOICE belongs to exactly one BOOKING

Make your own diagram like this

Describe your own system in plain English and the AI ER diagram generator draws it in seconds, in the same style as this template.

Related templates

Use CaseStudent Projects (College Reports)

Library Management System Use Case Diagram

Who uses a college library system and what each of them can do: members, the librarian and the system administrator.

Database ERDStudent Projects (College Reports)

Library Management System ER Diagram

The database of a library system: books and their copies, authors, members, loans, reservations and fines, with keys and cardinality.

Data FlowStudent Projects (College Reports)

Library Management System Data Flow Diagram (Level 1)

How data moves through a library system: members and the librarian, the main processes, and the data stores they read and write.

Class UMLStudent Projects (College Reports)

Library Management System Class Diagram

The main classes of a library system with attributes, methods and UML relationships.

SequenceStudent Projects (College Reports)

Library Management System Sequence Diagram (Issue a Book)

The steps when a member borrows a book: checks, loan record and the copy status update.

Use CaseStudent Projects (College Reports)

Online Examination System Use Case Diagram

What students, examiners and the administrator do in an online examination system.