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