Creating and Using Stored Tables › Outlining an Application › Step 1: Determining the Required Tables

Step 1: Determining the Required Tables

Fran wants her employment application to do the following:

• Collect, sort, and store job information
• Collect, sort, and store applicant information
• Match qualified applicants with available positions

Fran determines that she needs three tables in her application, as follows:

• A stored table to contain the job information
• A stored table to contain the applicant information
• A view that combines information from the JOB and APPLICANT stored tables