You want to extend the schema shown in Table to include information about customer payment...

You want to extend the schema shown in Table 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

REQUIRED

a. Modify the set of tables in Table 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.

TABLE Database That Needs to Be Extended