Question: Micro loans are small loans, which is beginning to gain popularity especially among borrowers in developing countries. The idea is to bring venture lenders together

 Micro loans are small loans, which is beginning to gain popularity

Micro loans are small loans, which is beginning to gain popularity especially among borrowers in developing countries. The idea is to bring venture lenders together using information technology. Typically, the loans will be used to finance startup or development of the borrower's company, so that there is a realistic chance for repayment. The money in a loan can, unlike traditional loans, come from many lenders. The following relational schemas are used to register information on the repayments on micro loans. Borrower(borrower_id, name, address) LoanRequest (loan_id, borrower_id, request_date, loan_amount) : Repayment (loan id, repayment_date, repayment_amount) A borrower is identified with a unique borrower ID and has only one name and address. Borrowers can have multiple simultaneous 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. (i) Write an SQL statement that(returns all repayments)from the borrower named "Tommy Fernando", and where the loan amount exceeds USD 1000. Show the borrower ID, name, request date, loan amount, repayment date and repayment amount. (ii) Write an SQL statement that shows the total repayment a mount

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!