Before starting this problem, you should consult the customer master file record layout in Figure 3.6 (page 76).
REQUIRED: Using the database software indicated by your instructor:
a. Create the "structure" for the records in the customer file. Use Figure 3.6 as a general guide to the data elements to be included in the customer records. However, observe the following specific requirements:
(1) Devise your own coding scheme for the "customer number."
(2) For the customer address, provide three separate fields, one each for street address, state, and ZIP code.
(3) Provide for two additional data elements that are not shown in Figure 3.6 (because they normally would be accessed from other files)-open sales orders and accounts receivable balance
b. If the software package supports a function to design input screens, create the screen format to be used for entering customer data.
c. Create hypothetical customer records and key the data into the database. The only design constraint is to use a variety of names, street addresses, states/ZIP codes, open sales order amounts, accounts receivable balances, and credit limits. (The number of records will be indicated by your instructor.)
d. Obtain a printout of the database records.
