Quote:
Originally Posted by shaunthomson
Is this an example of a normalised tagging system, or is it what you have been saying is not normalised...?
|
It is normalized but it may still contain unnecessary fields - depending on whether the name fields are unique within the tables and depending on the size of the name fields.
If the name fields are unique and relatively small fields then none of the id fields are needed.
I can't see the purpose for the id field on the tagmap table regardless as the other two fields together should be the primary key for that table.