FIT100
DB Design Paradigm
Guidelines for good databases:
•Build physical DB to avoid redundancy, etc
•Each physical table represents 1 entity
•Expect that no physical table gives any user their exact view
•To build view, build a query that ...
•   Joins tables together into a ‘super’ table
•   Trims out only the items the user wants
These guidelines are not an algorithm, but they usually produce good results