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.
This looks mostly complete, though the
BookingID field in
Guest 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 between
GuestID, you can probably remove
Guest. A similar thing can be done in
Bill as, if you know the
BookingID then you know the
GuestID can be removed from
Bill … if you choose, of course. You don’t need to make either change.