$4\mathrm{.}7$ You want to extend the schema shown in Table $4-16$ to include information about cus$-$

tomer payments. Some customers make installment payments on each in voice. Oth$-$

ers 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

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

tributes are primary and foreign keys, and enter sample data in each table you

create.

TABLE $4-16$ Database That Needs To Be Extended