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.
many to many relationship we need ak separate table for key
so this information should appear as an attribute of Lodging
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....???