2017 PROJECT

By

KCSE 2017 Computer Studies Project: Mwanzo Baraka Information Management System

Instructions to candidates
(a) Candidates are expected to use a Database Management System when developing their projects.
(b) A soft copy of the work done must be stored in a removable storage medium (CD-R/CD-RW).
(c) Your name and index number should appear on the cover page of your documentation and on the storage medium.
(d) Each candidate should hand in a hard copy and a soft copy of the project documentation.
(e) Candidates should answer the questions in English.

Question.

Mwanzo baraka 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; group and individual. Group membership constitutes two or more individuals who have common interests. An individual member pays a registration fee of 2000 while a group pays 5000. During registration, 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 Ksh.1000 to the organisation. For those registered under a group, each individual member contributes a monthly share of not less than ksh.1000 where ksh.200 is the group share contribution by a 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 atrracts an interest rate of 1% per month on the principal amount borrowed. a group can also get a group loan amounting to 3 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 the defaulted amounts. 60% of this amount is paid as dividends to the shareholders each getting an amount proportionate to their total share contribution. the balance is returned to run the organisation.
Design a computerised database system with its documentation for the Mwanzo Baraka organisation 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 loans borrowed.
5. Compute loan repayments and interest.
6. Compute income for the organisation
7. Compute dividends to each shareholder.
8. Generate reports on demand.