International Charity Foundation (ICF) is a private ancillary fund that partners with Australian OAGDS (Overseas Aid Gift Deduction Scheme) organisations and In-country Facilitators. The chairman of ICF is Mr. Colin MacFarlane. ICF helps motivated young people realise their potential through medical and educational assistance in various countries.

Current Manual Process

Children, who would like to enrol into ICFs program, need to fill a paper based form to give their personal details, health condition and type of support needed. The enrolment form and associated documents about each child are kept as hard copies at each branch office of ICF. Admin staffs will then manually process the submitted document and enrol the children into relevant programs. One child could be enrolled into multiple programs for both medical and educational supports. Sponsors go online to the websites and look up bank details of ICF. They then go and make a payment via bank transfer to the ICF trust account. Some individuals chose to go to a branch and deposit money directly into the ICF account. After that the sponsors either call or email ICF to leave their details to get a receipt. Because of the OAGDS, ICF can issue tax-deductible receipts for donations to their overseas aid activities. Once the funds are received at the end of each week the accountant generate receipts manually for each individuals and organizations, and then either send to them via emails or Australia post. P Each week, supplies such as food, medicine, medical equipment, etc.are ordered by the admin staffs of ICF at the central office in Australia. Prior to ordering the supplies, the admin staffs in Australia rings around each branch to determine the existing stock levels and estimated number of supplies required each week. The stock level is mainly kept track of using paper based documents, which could be out of date at the time of query. Information about expense on medical treatment and other operations are kept on excel files in computers at the local offices.

Desired System

Colin decides to engage you as an IT consultant, to provide his organization with solutions that address the above mentioned issues and advice on what needs to be implemented in the future. Colin wants a system that allows for children to enrol into ICF programs using online applications forms. Details about personal information, health conditions and type of assistance should be kept in a database, where admin staffs in any country can quickly process and enrol children into appropriate programs. The system should allow Individuals and organizations to donate money, sponsor specific programs, and create scholarships directly through ICF website. The donation can be made as one off payment or repeated payments. When a sponsor makes a contribution online, they should automatically receive an email thanking them for their contribution. Also the contribution is stored under client login so at the end of the year clients can either print a consolidated statement or download a statement from their account. Colin also wants the stock level at each branch should be kept track of through the online system. Ordering of supplies for the each branch to be automated and carried out when needed, rather than manually once a week as in the current process. The system should automatically kept track of income and expense for all branches so that statements can be created accurately and effectively monthly and yearly.

Questions:

1. Find out all Critical Use Cases and Draw User Case Diagram.

2. Draw Context Level Data Flow Diagram.

3. Draw Level 0 Data Flow Diagram depicting all the business process description provided.

4. Draw Entity Relationship Diagram showing all required entities and its relationships.

5. Create CRUD table.