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.
computer science
Description
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. In this problem, you must create an E-R model that describes the information necessary to manage micro loans. The following information form the basis for creating the model:
• Each borrower and lender must be registered with information about name and address.
• A loan starts with a loan request, which
contains information about when the loan should at latest be granted, The total
amount being discussed (US-dollars), and how long the payback period is. Also,
a description is included of how the money will be used. The rent on the
payment is calculated in the loan amount, which is to say, the full amount is
not paid .
• Lenders can commit to an optional portion of the total amount of a loan request.
• When the commitments for the loan request covers the requested amount, the request is converted to a loan. If not enough commitments can be reached, the loan request is cancelled. A borrower can have more than one request, and more than one loan at a time, but can at most make one request per day.
• The loan is paid through an “intermediary”, typically a local department of a charity, who has a name and an address.
• The borrower chooses when he or she will make a payment. Every
payment must be registered in the database with an amount and a date (at most one payment per loan per day). The lenders share the repayment based on how large a part of the loan they are responsible for.
• If the loan is not repaid before the agreed upon deadline, a new date is agreed. The database must not delete the old deadline, but save the history (the deadline can be overridden multiple times).
• Each lender can for each burrower save a “trust”, which is a number between 0 and 100 that determines the lender’s evaluation of the risk of lending money to that person. The number must only be saved for the borrowers, for whom there has been made such an evaluation
a) Make an E-R model for the data described above. If you make any assumptions about data that doesn’t show from the problem, they must be described. Use the E-R notation from KBL. Put an emphasis on having the model express as many properties about the data as possible, for instance participation constraints. Make a relational data model for micro loans
b • Describe at least two of the relations using SQL DDL (make reasonable assumptions about data types), and
• state the relation schemas for the other relations. The emphasis is if there is a correlation between the relational model and the E-R diagram from a), along with primary key and foreign key constrains being stated for all relations. It is not necessary to state CHECK constraints and the like.
c.Write an XQuery expression that for each borrower in loaners.xml computes the total amount, which is to say the sum of the numbers in the amount elements, minus the sum of the numbers in the repayment attribute of the repayment elements. The output must be valid XML that for each borrower states name and outstanding amount (in a debt element).
d. Use the operations of Named bank in Nigeria, preferably a bank where you operate any form of account, and discuss the scarios above using the event activities of the said bank. Draw appropriate ER diagram that suits the scenario of the new bank
e. Write an algorithm that will recommend the approval of LOAN to an applicant considering the conditions stated herein.
