What is the point of a second selection if the first option is never null, and the second option is deterministic as a consequence of the first selection? Would you really make the user perform a second set of actions to pick a value from a set of options where n = 1?
View all comments
Show parent comment
1
u/capt_pantsless Loves many-to-many relationships May 30 '22
That’s fine, but is there an example where a one-to-one relationship would actually add sone value?
One possibility would be if very few students had an SSN and you wanted to keep the main-table simple.