in reply to OT: benefits of database normalization

May I suggest a third design?

NamesAndAliases

NAA_idNameDefinition_id
1Foo1
2Foo_bis1
3Bar2

Definitions

Def_idDefinition
1A Foo-ish thing
2A Bar-ish thing

All names and aliases are in one table, if you wish, you can add another column to distinguish between names and aliases, although I see no real necessity.

All definitions are in a second table, so updating this table automatically updates the definitions of all related names and aliases.

Update: I only now see that I said the same as the AM in Re: OT: benefits of database normalization

CountZero

"If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law

  • Comment on Re: OT: benefits of database normalization