3 ms·
Sets up a straw-man: Article table like: authorID, authorName, publisher, title Where an article only ever has one author. Then proceeds to knock it down
by Groxx 16y ago
Sets up a straw-man:
Article table like:
authorID, authorName, publisher, title
Where an article only ever has one author. Then proceeds to knock it down (summarized and slightly satirized):
>That's not even in second normal form. /makes an Author table. Viola! Future name changes are free.
>But wait! We don't change author names on published articles! * gasp * we don't need joins!
No, you've just demonstrated that blind optimizations are sometimes incorrect. Duh. They are correct in this respect, however:
>The dogma of normalization [too] often leads to over-engineering.
But all dogmatic adherence to X results in sometimes-incorrect use of X. This is true everywhere, not just for RDBMS normalization.