I have make a ERD. And there is a case.
Can someone look to this both?
Did I forget something?
Would anything else have to be done?
my case is:
A hotel guest can be a main guest or a travel companion. Only a major guest can book and check out. A reservation is an appointment between the hotel and a principal guest for a future stay in a room of a particular room type. The reservation will be converted into a stay upon check-in. A stay is a continuous period in which certain hotel guests stay in a specific room. There is the limitation that every traveling companion belongs to a guest guest staying in the same period. A room type may, depending on the season, have a different accommodation price. During a stay, more services can be used.
thanks in advance