News for hackers. Stuff that matters.
Re:What does First Normal Form mean? by bart_spoon on Friday June 18, 2021 @07:32PM (#27556222)
I think a natural key that I’ve encountered is a database containing professional NBA data. Teams never play more than once per day, and there are only two teams in the game, so a natural (composite) key for games is simply the date of the game and the two teams that played. You can create a “game ID” if you wish, but you aren’t actually doing anything but adding a column of redundant information.

There are no comments on this comment yet.