Customers may make payment to cover one or multiple invoices. Add additional tables in the database to show customer payments. You want to record the following information: cash receipt number, date of receipt, total amount received and amount applied to a specific invoice.
Record the following information in the new table(s): On Oct 31 received $2,300 payment from D Ainge (receipt#1031001). $898 of the payment applies for invoices 103 and the rest applies for 101.Design the query to show the customer name, invoice amount,invoice date, payment date, payment amount of invoice 101.