Building Logical DBs
With the design in hand, formulate
tables using this strategy :
Catalog what tables will provide the
information for a given view table
Create a supertable (probably using join)
containing all data in the view table
Decide which fields are needed and in
what order
Formulate an SQL query for the table