Redundancy is Very Very Very Bad
Database design is the process of setting up a database schema
Not every design is good … avoid redundancy
Information is redundant if it is stored in multiple places in a database
Example: UW groups needing your home address
- Administration -- to send tuition bills
- Dean -- to send notification of being on “Dean’s List”
- IMA -- to send you back your locker deposit
Multiple copies of the same information can have different values
in different locations, i.e. be inconsistent, its worse than no data