A Foreign Key Constraint is translated into "Zero or One". But with a Not Null Constraint it is "Exactly One".