News for hackers. Stuff that matters.
Re:What does First Normal Form mean? by dragonwriter on Friday June 18, 2021 @06:54PM (#27555898)
> The textbook case would be student IDs in a university database where each row corresponds to a single student

“Student IDs” are an example of surrogate keys, though they may be surrogate keys in a system predating and outside of the DB.

(And if the mapping between them and actual students are managed by an error-prone process outside of the DB, they probably aren’t good primary keys for a table of students.)

There are no comments on this comment yet.