Re:What does First Normal Form mean?
by mulmen on Saturday June 19, 2021 @04:41PM
(#27564284)
Great! Then if they are unambiguous they can be inserted directly or disambiguated and then inserted. At query time any format can be used to represent them to a user.
[ Parent
| on HN ]
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.
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.