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.
Congratulations, you just created another synthetic key for describing dates.