Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Short Description of AssignmentUse the hypothetical Association AMMI to apply the knowledge earned so far in order to Analyse and Design an Information System to

Short Description of AssignmentUse the hypothetical Association AMMI to apply the knowledge earned so far in order to Analyse and Design an Information System to cover the Associations needs. We are going to use a free CASE tool called Zoho Creator. See the document Build a Custom CRM with Zoho CreatorAMMI DescriptionAMMI 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 TreasurerThe 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: (marked with yellow) use these to Build the DFD 1. Secretary sends email to Sponsor with Sponsorship Opportunities2. Sponsor either rejects or accepts a Type of Sponsorship by email and sendsInvoice Details3. Secretary Registers Sponsor with a Type of Sponsorship (Silver or Gold)4. Manager issues a Sponsorship Invoice5. Secretary Saves Invoice, Prints Invoice & emails Invoice6. Sponsor pays sponsorship to a BANK7. Manager checks BANK and issues Sponsorship Receipt8. Manager Registers a Member9. Member Pays Annual Membership to a Bank10. Manager checks BANK and issues Membership Receipt (Note: BE CAREFUL HERE: Processes are ACTIONS described by VERBS, while Data Flows are ENTITIES containing Data and described by NOUNS). External Entities: Member, Sponsor, Secretary, Bank, Manager Data Flows: Sponsorship Opportunities, Invoice Details, Member Contact Details, Sponsor Contact Details Files-Tables: Member Contact Details, Sponsor Contact Details, Accounting FileData Structure for Sponsor1. Company Name2. Profession3. Address Str & No4. Postal Code5. Country6. Contact Name7. Tel#18. Tel#29. Email of Company10. Email of Contact11. VAT Code (International)12. Join Date13. Sponsorship Amount14. Sponsorship Start Date15. Sponsorship End Date Data Structure for Member1. Name2. Surname3. Address4. Company5. Job Description6. Tel#17. Tel#28. Email9. VAT Code Data Structure for Sponsorship Invoice1. Date2. Invoice no3. Company Name4. Address5. VAT No6. Sponsorship Code7. Sponsorship Description Your Task is:1. Using the above information, prepare the Analysis Report which must consist of:a. User Requirements (5 points)b. Data Flow Diagram (5 points) of all processes. Mark the Domain (boundaries) to be automatedc. Data Dictionary (5 points)(ie: the Data Flows in terms of the Data Structures and Data Elements)2. Design the User Interface using Zoho Creator (35 points)a. the screen that will be used by the users to enter/modify data for Membersb. the screen that will be used by the users to enter/modify data for Sponsorsc. the screen that will be used by the users to issue a Sponsorship Invoiced. the screen that will be used by the users to issue a Membership Receipte. the screen that will be used by the Accountant to issue a Membership Receipt

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2018 Dublin Ireland September 10 14 2018 Proceedings Part 1 Lnai 11051

Authors: Michele Berlingerio ,Francesco Bonchi ,Thomas Gartner ,Neil Hurley ,Georgiana Ifrim

1st Edition

3030109240, 978-3030109240

More Books

Students also viewed these Databases questions

Question

Describe a persuasive message.

Answered: 1 week ago

Question

Identify and use the five steps for conducting research.

Answered: 1 week ago

Question

List the goals of a persuasive message.

Answered: 1 week ago