Question 4) Consider the following relations Question "uua Consider the following relations: Borrower borrower id, name, address) Loanlloan id, borrower, id, requestdate, loanamount) Repaymentborrower idloan id repayment date repayment amount) Assume that the following four SQL commands are known to be frequent: SELEC DISTINCT name, address x Repayment RHERE borrower id ANp repaymens date ELaC borrower id, loananount FROM Lcan A) Suggest one or more indexes, taking into account the above. State the indexed attribute and argue shortly for your choices. B) Suggest one or more partitioning options, taking into account the above. State the partitioning attributes and the type of partitioning. Argue shortly for your choices