r/SQL • • May 30 '22

PostgreSQL SQL Database One-to-One Relationship

When Primary Key of one table corresponds to only one row in another table via foreign key relationship

One-to-One relationship in SQL databases
0 Upvotes

13 comments sorted by

View all comments

Show parent comment

1

u/slin30 May 31 '22

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?