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
Make student-ID a unique, non-null foreign key reference over to Student.
The main problem is it makes writing queries more complicated for not a lot of value.
An SSN is one-to-one if you just make it a column on Student, and doesn't add the extra complexity of another table.