Scribd
Upload
23 views1 page

Project Erd Draft

The document outlines the Entity-Relationship Diagram (ERD) for a Hotel Booking System. It includes three main entities: Room, Booking, and User, detailing their attributes and relationships. Each Room can have multiple Bookings, and each Booking is associated with a User and a specific Room.

Uploaded by

Easy TO Solve
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
23 views1 page

Project Erd Draft

The document outlines the Entity-Relationship Diagram (ERD) for a Hotel Booking System. It includes three main entities: Room, Booking, and User, detailing their attributes and relationships. Each Room can have multiple Bookings, and each Booking is associated with a User and a specific Room.

Uploaded by

Easy TO Solve
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Hotel Booking System ERD

ROOM

PK - id : long
- roomType : string
- roomPrice : BigDecimal
- roomPhotoUrl : string
- roomDescription : string
- bookings : List<Booking>

BOOKING

PK - id : long
USER
FK - room_id : long
PK - id : long FK - user_id : long
- email : string - checkInDate : LocalDate
- name : string - checkOutDate :
- phoneNumber : string LocalDate
- passsword : string - numOfAdults : int
- role : string - numOfChildren : int
- bookiings : - totalNumOfGuests : int
List<Booking> - bookingConfirmationCode
: string
- room : Room
- roomUser : User

You might also like