Find Jobs
Hire Freelancers

Build a database

$10-30 USD

Ditutup
Disiarkan lebih dari 6 tahun yang lalu

$10-30 USD

Dibayar semasa penghantaran
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
ID Projek: 15058635

Tentang projek

6 cadangan
Projek jarak jauh
Aktif 6 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
6 pekerja bebas membida secara purata $90 USD untuk pekerjaan ini
Avatar Pengguna
Hi, I'll enhance your DB juston your need. Relevant Skills and Experience vba, Excel, sql, ado, Access Proposed Milestones $333 USD - default
$333 USD dalam 10 hari
4.6 (40 ulasan)
6.0
6.0
Avatar Pengguna
Please review my profile. Relevant Skills and Experience I have 7 years and 9 months experience in SQL. Proposed Milestones $24 USD - MS ACCESS Please let me know more details and when we will start. Sky pe: jikenjd
$24 USD dalam 0 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera KENYA
Kenya
0.0
0
Ahli sejak Ogo 30, 2017

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.