Re: How to prove that your tables have been fully normalized?
Normalization is actually fairly simple. To convert data from one form to another you apply a single, simple, rule to that data. To move to the next level of normalization apply the next rule etc. etc. See http://en.wikipedia.org/wiki/Database_normalization.
So examine your data and see if it conforms to these rules. If it does then it is normalized. If it doesn't then it is not.
However reducing data into its 3rd normal form does not necessarily make it totally suitable for use within a DB. You then have to OPTIMIZE the data. During this exercise you may denormalize parts of the data to give faster access to the information. So you now have to go back to your DB designer and ask what were the decisions made in the normalization & optimization of the data.
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Unsolved 
