Learn how to extend a schema 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

a.Modify the set of tables inTable4-16to 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.