Consider the entities 'hotel room', and 'person' with a many to many relationship 'lodging' as shown below:
If we wish to store information about the rent payment to be made by person (s) occupying different hotel rooms, then this information should appear as an attribute of
Lodging is the only attribute relating person and hotel room.
what if the relationship is 1 to many?
relation 1 to many says that ....a single hotel_rooms is allocated for many persons but a single person has only one rooms allocated...there for attribute rent can be the part of Person entity....???
Feedback for next edition (if ever there's...