2020 PROJECT
KCSE 2020 Computer Studies Project: Fedha Youth Group 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
Fedha
Youth Group is an organisation formed by youths for purposes of saving money
and giving loans to members. Eligible members are youths aged 18 to 35 years
who intend to start or improve their personal business ventures.
For
one to become a member of the group, a non-refundable registration fee of Kshs
1,000 must be paid. Every member is required to contribute a minimum amount of
Kshs 500 every month as shares contribution.
When
a member contributes for at least six consecutive months, he or she is eligible
for a loan. The loan applied for depends on the total shares contributed by a
member, the intended repayment period and the type of loan borrowed. The
interest rate charged on the loan depends on the type of loan as shown in the
following table.
 |
| Fedha Youth Group System Loan Types |
Each
member applying for a loan is required to be guaranteed by other members of the
organisation. The total amount guaranteed by the other members should be equal
to or more than the mount borrowed less the shares of the borrower. All the
savings that are not borrowed are kept in the bank as fixed deposit and earns
interest at a rate of 0.6% per month.
Any
member wishing to exit from the organisation is required to give a one month
notice and to have paid back all the outstanding loans borrowed. The loans that
the exiting member has guaranteed other borrowers must also have been paid
back. Upon expiry of the one month notice, the exiting member is reimbursed the
full amount of shares he or she has contributed to the organisation.
At
the end of every year, the total revenue earned from the loans borrowed and
from the fixed deposits is computed. From this amount, 10% is retained for
office expenses and the balance is shared among the members as dividends on
shares. The amount of dividends allocated to each member is based on their
respective share contributions to the organisation.
Develop
a well-documented computerised database system that would be able to:
(a) maintain a list of the:
(i)
members in the organisation and their registration fees;
(ii)
types of loans;
(iii)
loans borrowed by each member;
(iv)
fixed deposits;
(v)
guarantors for each loans borrowed;
(vi)
shares for each member.
(b) compute each of the following:
(i)
total registration fees;
(ii)
total shares;
(iii)
maximum loan qualified for;
(iv)
interest on loans borrowed;
(v)
interest on fixed deposits;
(vi)
monthly repayments on the loans borrowed;
(vii)
dividends payable to members;
(viii)
guaranteed amount for each loan borrowed;
(ix)
amount retained by the organisation for office expenses.
(c) generate each of the following
reports:
(i)
members registration fees;
(ii)
share contributions;
(iii)
fixed deposits;
(iv)
loans borrowed
(v)
loan repayment schedule per member;
(vi)
the balances after every repayment;
(vi)
dividends payable to each member.