Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Management Databases And Organizations

Authors: Richard T. Watson

3rd Edition

0471418455, 978-0471418450

More Books

Students also viewed these Databases questions