FIT100
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