I tried creating an ERD model for hotel reservation and billing. Are the cardinalities correct, I'm a bit confused about that. And are there any attributes that are not in the right place? If someone could help me and go over this I would appreciate it. Thank you.
Entity Relationship Diagram for Hotel
erd
Related Question
- How to model a medical scenario in an entity-relationship diagram
- Foreign Key as Primary Key when “converting” conceptual entity-relationship elements to logical relations
- How to create a correct entity-relationship diagram (ERD) about a video game profits scenario
- Postgresql – Chat/conversation history, entity relationship diagram
- Domain of Attributes for an Entity
- Issues Designing ER Diagram
Best Answer
This looks mostly complete, though the
BookingID
field inGuest
seems a little pessimistic. What will you do if a guest wants to stay at the hotel again in the future? As you already have a relation betweenGuest
andBooking
viaGuestID
, you can probably removeBookingID
fromGuest
. A similar thing can be done inBill
as, if you know theBookingID
then you know theGuestID
. SoGuestID
can be removed fromBill
… if you choose, of course. You don’t need to make either change.