Re: Is my database normalized?
Given that MaxHP can be computed from cClass and Level (via the ClassStats you proposed, then MaxHP is not really normalized.
Won't you repeatedly access MaxHP for a 'user'? So, it is more practical to have MaxHP in CharacterStats.
On the other hand, will InitialHP or HPGrowth ever change? Is there is a chance of them changing, then the 'right' way to design the tables is to have ClassStats and calculate MaxHP all the time. To look at it another way... When something changes, do you have to run around and fix lots of values in other table(s)? If so, the schema is 'wrong' and needs more normalization.
When you get millions of rows, performance issues tend to trump normalization purity.
Subject
Written By
Posted
Re: Is my database normalized?
June 27, 2010 04:28PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.