Use only Ms access 2003-2007 (strictly)
UMOJA MANAGEMENT INFORMATION SYSTEM
Umoja organisation is a self-help group intended to improve the economic status
of its members through pooling of financial resources. The organisation sustains
itself through registration fees of its members, monthly contributions, interest
accrued through loans given to members, and penalties for delayed payments.
The members benefit by getting cheap loans from the organisation.
Membership to the organisation is by registration. There are two types of
membership; individual and group. Group membership constitutes two or more
individuals who have common interests. An individual member pays a registration
fee of Kshs. 2,000 while a group pays Kshs. 5,000. During the registration of
individuals, personal details are captured. When registering a group, details of the
group and those of its individual members are captured.
An individual member contributes a monthly share of not less than Kshs. 1,000 to
the organisation. For those registered under a group, each member contributes a
monthly share of not less than Kshs. 1,000 where Kshs. 200 is the group share
contribution by the member. All monthly contributions are treated as shares for
the contributor and attract annual dividends.
Members can borrow loans from the organisation based on their total shares.
Members registered as individuals can be loaned up to three times their share
contribution. The repayment period does not exceed three years and the loan
attracts interest at a rate of 1.2% per month on the principal amount borrowed.
Members registered under a group can be loaned up to four times their individual
share contribution. The repayment period does not exceed four years and the
loan attracts an interest at a rate of 1% per month on the principal amount
borrowed. A group can also get a group loan, amounting to three times the
group’s total share contribution which attracts interest at a rate of 0.8% per
month payable within five years. All payments to the organisation are monthly
and must be made by the last day of the month. Any defaulted payments are
penalised at a rate of 10% per month.
Every end of the year, the organisation determines the total interest charged on
all loans and total penalties on defaulted amounts. 60% of this amount is paid as
dividends to the shareholders each getting an amount proportional to their total
share contributions. The balance is retained to run the organisation.
Design a computerised database system with its documentation for the Umoja
organization that should be able to:
1. Maintain records of members and groups.
2. Maintain records of registration fees.
3. Maintain records of monthly contributions.
4. Maintain records of loan borrowed.
5. Compute loan repayments and interest.
6. Compute income for the organisation.
7. Compute dividends to each shareholder.
8. Generate reports on demand