here is a part of my ERD "Hotel Reservation system"
and there is a relationship with 3 entities included in it.
the relationship between them is "assign to"
I make it as 1 to 1 relationship
and i want to know than , how to make normalization for it?
take the pk of one of them to the other remaining entity
and thats it !
or what ?