Skip to content
Advertisement

Which is the correct form to create one to many relationships between two tables on a Oracle database

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: enter image description here

or creating a direct relationship like this

enter image description here

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.

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement