Three-Valued Logic

Re:Three-Valued Logic by mannykannot on Friday December 15, 2017 @10:34AM (#15932473)

For the purposes my question, it would be a complication, but resolvable by using a unique identifier. Perhaps I should have limited my speculation to databases that are in at least first normal form.

[ Parent | on HN ]

Re:Three-Valued Logic by jessaustin on Friday December 15, 2017 @12:47PM (#15933551)

I'm not sure how the 1NF limitation helps the question. One-to-many relations can certainly exist in 1NF. If the question is amended to specify that the table that represents the nullable column must have its primary key also be its foreign key to the main table, then I agree that the answer is "yes".

[ Parent | on HN ]

Re:Three-Valued Logic by mannykannot on Friday December 15, 2017 @01:04PM (#15933699)

I thought 1NF was a solution to a follow-on problem with handling repeating groups, that, on reflection, I see does not exist.

[ Parent | on HN ]