|
|
|
|
|
|
|
|
|
|
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
|
|