I have these 3 scenarios:
Rooms located in a house are assigned a room number within that house - thus, for example, each house has a room number 1. Each room has a phone number etc...
My guess is we do not need to have a separate entity for rooms since each house must have one room then if we delete the room we should delete the house anyway?
A tour guide(identified by tour guide id) may have one or more specialisations but not all tour guides have them.
Specialisations should be a separate class?
If an activity is performed by a Tourism Provider do not record the details of the Tourism Provider who completed the activity.
Should Tourism Provider even be a separate entity because we are not recording the details?