Question: Question 2: SOL (10pts) The following relation schema can be used to register information on the repayments on micro loans Repayment(borrower id,name,address,loan amount, request date,repayment_

Question 2: SOL (10pts) The following relation schema can be used to register information on the repayments on micro loans Repayment(borrower id,name,address,loan amount, request date,repayment_ date,repayment a mount) A borrower is identified with a unique borrower id, and has only one address. Borrowers can have multiple simultancous loans, but they always have different request dates. The borrower can make multiple repayments on the same day, but not more than one repayment per loan per day. a) State a primary key for Repayment (1pts) b) Write an SQL reque st that returns all the tuples with information on repayments from the borrower with id equal to 42, and where the lent amount exceeds 1000 USD. (3pts)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
