Micro loans are small loans(), which is beginning to become popular 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 borrowers company, so that there is a realistic chance for repayment(). In this problem, you must create an E/R diagram that describes the information necessary to manage micro loans. The following information form the basis for creating the model:

1. Legal entity() includes borrower, lender, and intermediary(). Each borrower, lender, and intermediary must be registered with information about an unique id, a name and an address.

2. A micro loan contains information about request date that the loan should be granted(), loan amount being discussed (in NT$), how long the payback period is (payday). Also, a description is included of how the money will be used. The rent on the repayment is calculated in the repayment amount, which is to say, the full loan amount is not paid.

3. Lenders can commit to a portion of the loan amount, called committed amount.

4. When the commitments cover the loan amount, micro loan is constructed. A borrower can create more than one micro loan at a time, but can at most make one loan per day.

5. The micro loan is paid through an intermediary, typically a local department of a charity().

6. The borrower chooses when he or she will make a repayment from a micro loan. Every repayment must be registered in the database with a repayment amount and a date (at most one repayment per loan per day).

7. A deadline should be set by an agreed date and a due day(). The database must not delete the old deadline, but save the history (note that: due day can be overridden() multiple times).

8. For each borrower, a lender can save a trust, which is a percentage between 0 and 100 that determines the lenders evaluation of the risk of lending money to that borrower.

(b) Make a relational schema for the above E/R diagram of micro loans. (Note: You can use any method to handle subclass transformation.)