Lets say that we have two entities Entities:
- Bus (idBus*)
- Stop (idStop*,stopDescription)
Where a Bus passes from many Stops and vice versa, therefore the cardinality is N:N.
My question arises from the fact that when we consider to know the
idStop and the
idBus then we will also know a number of attributes like
How should i map those attributes?
My thought is to make a bridge table having
idBus as Foreign Keys and a number of extra attributes that are not present in either the Bus or the Stop table, but I don't know if this is doable or the correct way to go.