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 (borrower_id, name, address, loan_amount, request_date, repayment_date, repayment_amount)
Schema Description:
A borrower is identified with a unique borrower_id, 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. (03 Points)
B. Deletes all information of ended douns. toan is ended if the total of its repayment_amount equals to loan anount (03 Points)
C. Write an SQL statement to find the sum of the toan amounts for each borrower. (02 points)
D. Write an SQL statement to find the coint the nunger of borgowers who have more than 2 simultaneous loans, (02.Points)
 Consider the following relation schema: Repayment (borrower_id, name, address, loan_amount, request_date,

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!