There is a one-to-many relationship between customers and loans (customers is the one table).

• Modify the database so that when a loan is issued, we can track which employee processed the loan.
• Modify the database so that each payment is associated with a loan, and the employee receiving the payment is identified.
• Modify the database so that a loan can be associated with two customers (such as a husband and wife). Please answer with explonations

Thank you!

BankLoans: Database Tell me what you want to do Hem A AS Relationship Tools File Home Create External Data Database Tools Help Relationships Design Hide Table X Clear Layout Direct Relationships Edit Add - Relationship Report Close Relationships Tables All Relationships Tools Relationships All Access Obje... Customer Relationships Tables Customers Employees Customers Loans Loans 1 Customers * LoanID Payments FirstName Date LastName Amount Address InterestRate City Term State Type ZipCode Customerid PhoneNumber Employees FirstName LastName Street City State ZIP Telephone Date Hired TermDate EmpNo PayGrade Payments 1 LoanID 1 Date PaymentReceived