Question: Consider the following relation schema: Repayment ( borrower _ id , name, address, loan _ amount, request _ date, repayment _ date, repayment _ amount
Consider the following relation schema:
Repayment borrowerid name, address, loanamount, requestdate, repaymentdate, repaymentamount
Schema Description:
A borrower is identified with a unique borrowerid and has only one address.
Borrowers can have multiple simultaneous loans, but they always have different request dates.
The borrower can make multiple repayments on the smne day, but not more than one repayment per loan per day:
A Write an SQL statement to find the total repaid amount for each loan. Points
B Deletes all information of ended douns. toan is ended if the total of its repaymentamount equals to loan anount Points
C Write an SQL statement to find the sum of the toan amounts for each borrower. points
D Write an SQL statement to find the coint the nunger of borgowers who have more than simultaneous loans, Points
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
