Notice that we can always map 1:1 or l:N relationships in a manner similar M:N to relationships by using the cross-reference (relationship relation) approach, as we discussed earlier. This alternative is particularly useful when few relationship instances exist, in order to avoid null values in foreign keys. In this case, the primary key of the relationship relation will be only one of the foreign keys that reference the participating entity relations. For a 1:N relationship, the primary key of the relationship relation will be the foreign key that references the entity relation on the N-side. For a 1:1 relationship, either foreign key can be used as the primary key of the relationship relation as long as no null entries are present in that relation
In new table created for 1:1 or 1:N , does it include entries for all the entities or only those who are participating in relationship TO AVOID NULLS
ex: Table 1 or table how will it be ?
64.3k questions
77.9k answers
244k comments
80.0k users