Using only the tables and fields provided, answer the following question:

• Working in the accounts payables department, you have been asked to generate a report showing all outstanding balances by vendor # and PO #, including the specific vendor details (name and address).
• You have 4 tables to work with:
  • Invoices: invoice number, amount invoiced, PO number
  • Vendor Master: Vendor number, Vendor address, Vendor Name
  • PO: PO number, Vendor Number, Amount
  • Payments: Invoice number, amount paid, payment date, payment ID
• Draw a table diagram identifying the parent, child, and grandchild (if applicable) tables along with primary and foreign keys
• Describe the logic for developing the report.
• How, if any would your approach change if you were asked to find all vendor payments made that were over the originally procured value?