Use the hypothetical Association “AMMI” to Analyse and Design an Information System to cover the Association’s needs. We are going to use a free CASE tool called Zoho Creator. See the document “Build a custom CRM with Zoho Creator”

“AMMI” Description “AMMI” is an association with 150 Members and 50 Sponsors. Its purpose is to provide education to its members and act as a contact point between Members and Sponsors. “AMMI” has decided that a new CRM System is needed to replace the existing system. The main reason is to allow more than one user to update & consult the system from anywhere. The new system for “AMMI” will allow the management of Personal Details and Financial Status of Members and Sponsors of the Association plus the Accounting of the Association, via one integrated program. The existing system is PC based and consists of one Excel Worksheet for the Members, another Excel Worksheet for Sponsors, one program that manages the Sponsors and prints Invoices & Receipts, an Accounting program that manages Invoices and Expenses handled by an Accountant, and a paper archive of Invoices and Receipts managed by the Treasurer The new system must be Server-based or Cloud-based, allowing up to 5 users to work concurrently from PCs, Tablets and Mobile phones, send/receive emails and print several Reports. Processes: 1. Secretary sends to Sponsor email with “Sponsorship Opportunities” 2. Sponsor either rejects or accepts a “Type of Sponsorship” by email and sends “Invoice Details” 3. Secretary Registers “Sponsor” with a “Type of Sponsorship” (Silver or Gold) 4. Manager issues “Sponsorship Invoice” 5. Invoice is Saved, Printed & emailed 6. Sponsor pays sponsorship to a BANK 7. Manager checks BANK and issues “Sponsorship Receipt” 8. Manager Registers a “Member” 9. Member Pays “Annual Membership” to a Bank 10. Manager checks BANK and issues “Membership Receipt” External Entities: Member, Sponsor, Secretary, Bank, Manager Data Flows: Member Contact Details, Sponsor Contact Details Files-Tables: Member Contact Details, Sponsor Contact Details, Accounting File Data Structure for “Sponsor” 1. Company Name 2. Profession 3. Address Str & No 4. Postal Code 5. Country 6. Contact Name 7. Tel#1 8. Tel#2 9. Email of Company 10. Email of Contact 11. VAT Code (International) 12. Join Date 13. Sponsorship Amount 14. Sponsorship Start Date 15. Sponsorship End Date Data Structure for “Member” 1. Name 2. Surname 3. Address 4. Company 5. Job Description 6. Tel#1 7. Tel#2 8. Email 9. VAT Code Data Structure for “Sponsorship Invoice” 1. Date 2. Invoice no 3. Company Name 4. Address 5. VAT No 6. Sponsorship Code 7. Sponsorship Description Your Task is: 1. Using the above information, prepare the “Analysis Report” which consists of a. User Requirements b. Data Flow Diagram of all processes. Mark the Domain (boundaries) to be automated c. Data Dictionary (i.e.: the Data Flows in terms of the Data Structures and Data Elements) 2. Design the User Interface a. the screen that will be used by the users to enter/modify data for Members b. the screen that will be used by the users to enter/modify data for Sponsors c. the screen that will be used by the users to issue a “Sponsorship Invoice” d. the screen that will be used by the users to issue a “Membership Receipt” e. the screen that will be used by the Accountant to issue a “Membership Receipt”