News for hackers. Stuff that matters.
Re:What does First Normal Form mean? by jameshart on Saturday June 19, 2021 @04:54PM (#27564382)
Ah, so you're suggesting instead of storing 'what a person calls this date' as the key, you instead convert it to some underlying representation that you can then choose to present in different calendars - like a UNIX epoch-relative offset or something.

Congratulations, you just created another synthetic key for describing dates.

Re:What does First Normal Form mean? by goto11 on Monday June 21, 2021 @03:51AM (#27577164)
That is not what synthetic key means. A synthetic key is a key which does not carry any information, like an auto-incremented integer. A date is a natural key, regardless of the underlying representation.
Re:What does First Normal Form mean? by mulmen on Saturday June 19, 2021 @05:24PM (#27564586)
The date is a natural key. The format string is only a representation. Implementation details are irrelevant to the definition of a natural key.