Please help me with the correct answers

Question 4 (total 10 credits): Consider the following relations: Borrower(borrower id, name, address) Loan(loan id, borrower_id, requestdate, loanamount) Repayment(borrower id, loan id, repayment date, repayment_amount). Assume that the following four SQL commands are known to be frequent: SELECT DISTINCT name, address FROM Borrower WHERE borrower id = 2; SELECT FROM Repayment WHERE borrower_id = ? AND repayment_date > 25 SELECT borrower_d, loanamount FROM Loan WHERE loanamount BETWEEN 2 AND 2 HO a. Suggest one or more indexes, taking into account the above. State the indexed attributes and argue shortly for your choices. O 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. Honzontal paulit on by 10an Undunt Yordat huo, pradiny neu er each table / Horizontal paulitioning baditus 3 Verical Udio, Di Li Na 000 4 DIC (D are Paated