I have a Oracle database in which I have two tables, RegistroPPL and Alias. One RegistroPPL can have multiple Aliases. Now, my question is, what is the right way to create this relationship, using a bridge table like this:
or creating a direct relationship like this
What is the best way to create one to many relationships according to the normalization rules, and how can I avoid redundant data?.
Advertisement
Answer
In my experience, the two-table design is used for one-to-many relationships.
The only reason I can think of you might want to use an intermediate table is if there’s some reason to think that in the future this might become a many-to-many relationship.