You want to extend the schema shown in Table 4-16 to include information about customer payments. Some customers make installment payments on each invoice. Others write a check to pay for several different invoices. You want to store the following information:

amount applied to a specific invoice cash receipt number customer name customer number date of receipt employee processing payment invoice payment applies to total amount received

Data from Table 4-16

REQUIRED

a. Modify the set of tables in Table 4-16 to store this additional data.

b. Identify the primary key for each new table you create.

c. Implement your schema using any relational DBMS package. Indicate which attributes are primary and foreign keys, and enter sample data in each table you create.

Transcribed Image Text:

TABLE 4-16 Database That Needs to Be Extended Inventory Item Number Description 10573 19" Monitor 10574 21" Monitor 10622 Laser Printer 10623 Color Laser Prii 10524 Multi-function 0 Record: 46 of 6 Record: 446 of 6 Y Customer Customer Number . Name 11255 G. Hwang 12971 J. Jackson 13629 P. Szabo 15637 5. Martinez 18229 B. Adams 0 Ha Y Quantity on Hand Street 2993 Main 466 W. Oak 246 E. Palm 2866 Spring 1744 Apache No Fier Search Search City Mesa Tempe Mesa Tempe Tempe AZ RRRRR AZ AZ AZ AZ ▾ 13 8 22 12 0 State X List Price Y $495.00 $949.00 $395.00 $699.00 $799.00 $0.00 Zip Code -Credit Limit Account Balance - $4,000.00 $5,000.00 85281 85286 85281 85287 85287 0 $6,000.00 $5,000.00 $3,000.00 $0.00 $875.00 $2,588.00 $3.955.00 $250.00 $1.675.00 $0.00