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

Question

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?.

标签： sqloracledata-modeling

Answer 1

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.