FIT100
Avoiding Redundancy
Redundancy is bad because it can lead to inconsistent data … very bad!
•Keep only one copy of any data
• … does that make it right???
•Rather than repeating data, reference it in the places where it is needed
• - Keep data in its own table
• - Save its key wherever it is needed 
When users want the data, get it using its key!