Creating and Using Stored Tables › Outlining an Application

Outlining an Application

To outline her employment application, Fran:

1. Determines the required tables by identifying the major categories of information to be processed.
2. Defines the columns for each table that label items of information within each category.
3. Specifies a unique key for each table: one column or a combination of columns that uniquely identifies each row of data in the table.
4. Establishes join columns: columns common to two tables that are used to combine the tables.