Hello, I need the ERD diagram created

Hello, I need the ERD diagram created
ChocAn Group Project Team 2 Project Charter Executive Summary 7/20/2022 Problem Statement Our goal is to design a system that can handle all the necessary information coming in and going out from ChocAn’s data center efficiently. The system should have 4 main entities: members ,service providers, Acme and the bank. Each entity needs to include important attributes that the business requires for data validation and information exchange between the entities. The ChocAn members pay a monthly fee to maintain their memberships to enjoy healthcare services from the providers.The processing of the payments of ChocAn’s membership fees and membership validation has been contracted out to Acme, a third-party organization. The provider side requires functionalities such as, recording services provided to active members, and billing the business.Once the provider bills ChocAn, the fee is audited by the system. A record consisting of EFT data is then written to a disk; baking computers ensure that each provider’s bank account is credited with the appropriate amount.The business needs to be able to manage records of active/inactive members/providers, run accounting procedures, and generate/send out reports. We need to design a system that can carry out all of these functionalities while paying attention to data integrity as well as keeping the design as simplified as possible. Purpose of the Project: Current State: [What is the issue, risk or gap we are trying to address] To keep an up-to-date lists of members and providers Keep the privacy of our customer and providers (medical records, payment information and etc) To minimize human error and improve process accuracy To restrict possible user input options to protect data integrity The system should be able to provide the functionality that would allow users to double verify and confirm their inputs Maintain consistency and enable traceability of past activities of the users Future State: [What is the future vision and how does this project address the issue, risk or gap] Members can delete/pause their accounts voluntarily. In addition, ChocoAn data center’s operators have the admin rights to add new members, delete members who have resigned, or suspend members who have not paid their membership fee for at least a month. The member entity will have an attribute called Previous Membership Payment Date, so each day, the operator can query the database to find out members with a Payment Date more than a month ago and run a batch request to suspend these accounts and send out notification emails, on a daily basis. Providers can make their profiles private (invisible for others) when they wish to temporarily pause their service contract with ChocAn. When they wish to terminate their service contract with ChocAn, they are required to submit a request form, so the system can be notified, and the business can pay them if there’s any outstanding balance then delete their account. Available services will be provided as a domain of attributes. The system will not allow user input for the Service Code field. It will be a drop-down box / search bar, so the providers can only choose from available options. Each service has a predetermined fee. The providers cannot charge a different amount of fee other than the predetermined amount. The amount of fee will be automatically displayed on the terminal screen when the provider chooses a service code from the drop-down box.Once the service is selected, the computer will automatically record the day and time . The predetermined amount of service fee will be displayed on the terminal screen when the provider enters the service code. The providers will also be asked to verify all the services he/she provided and the service fees at the end of each week. The sum is calculated automatically based on the reports the providers submitted.( In Discussion) The provider has to verify the member’s member card before every session using the terminal. Ideally, after each session, the provider will slide the member card through the card reader on the terminal again to record the provided session. But the provider will also be given the option to key in the Member Number (which can be found in the system when a member books a session with a provider) and record the session info later.A document will then be sent out to both the provider and member to verify a The members will also receive a weekly report if the system recorded that they had session(s) with provider(s). If the members see unknown sessions on the report, they can either submit a notice through the website or call ChocAn to notify them that they were not the one that received the session. Complete ERD Draw ERD for complete organization (i.e. depict all entities and relationships regardless if described in the problem statement/current/future state or not) – remember this describes anything that is a possible data model. 4 entities (Acme, the bank , the customer and the provider (maybe the database too). Our goal is to design a system that can handle all the necessary information coming in and going out from ChocAn’s data center efficiently. The system should have 4 main entities: members ,service providers, Acme and the bank. Each entity needs to include important attributes that the business requires for data validation and information exchange between the entities. The ChocAn members pay a monthly fee to maintain their memberships to enjoy healthcare services from the providers.The processing of the payments of ChocAn’s membership fees has been contracted out to Acme, a third-party organization. The provider side requires functionalities such as, recording services provided to active members, and billing the business.Once the provider bills ChocAn, the fee is audited by the system. A record consisting of EFT data is then written to a disk; baking computers ensure that each provider’s bank account is credited with the appropriate amount.The business needs to be able to manage records of active/inactive members/providers, run accounting procedures, and generate/send out reports. We need to design a system that can carry out all of these functionalities while paying attention to data integrity as well as keeping the design as simplified as possible. We should find a way to make sure that the service we are providing to the members is actually effective ( this may not be necessary in our project, most likely not ) Keep the privacy of our customer and providers( medical records, payment information and etc) Update our information everyday to Acme and the bank in case anything changes ( problem could occur when member cancels with us but nothing is sent to Acme and member gets billed ) We need a system to automate the process Privacy Processing time
Hello, I need the ERD diagram created
627 A Term Project: Chocoholics Anonymous Chocoholics Anonymous (ChocAn) is an organization dedicated to helping people addicted to chocolate in all its glorious forms. Members pay a monthly fee to ChocAn. For this fee they are entitled to unlimited consultations and treatments with health car e professionals, namely, dietitians, internists, and exercise experts. Every member is given a plastic card embossed with the member’s name and a nine-digit member number and incorporating a magnetic strip on which that information is encoded. Each health care professional ( provider ) who provides services to ChocAn members has a specially designed ChocAn computer terminal, similar to a credit card device in a shop. When a provider’s terminal is switched on, the provider is asked to enter his or her provider number. To receive health care services from ChocAn, the member hands his or her card to the provider, who slides the card through the card reader on the terminal. The terminal then dials the ChocAn Data Center, and the ChocAn Data Center computer veri es the member number. If the number is valid, the word Validated appears on the one-line display. If the number is not valid, the reason is displayed, such as Invalid number or Member sus- pended; the latter message indicates that fees are owed (that is, the member has not paid membership fees for at least a month) and member status has been set to suspended. To bill ChocAn after a health care service has been provided to the member, the provider again passes the card through the card reader or keys in the member number. When the word Validated appears, the provider keys in the date the service was provided in the format MM–DD–YYYY . The date of service is needed because hardware or other dif culties may have prevented the provider from billing ChocAn immediately after providing the service. Next, the provider uses the Provider Directory to look up the appropriate six-digit service code corresponding to the service provided. For example, 598470 is the code for a session with a dietitian, whereas 883948 is the code for an aerobics exercise session. The provider Appendix sch76183_appA_627-629.indd 627 sch76183_appA_627-629.indd 627 07/06/10 11:53 AM 07/06/10 11:53 AM 628 Appendix A T erm Project: Chocoholics Anonymous then keys in the service code. To check that the service code has been correctly looked up and keyed in, the software product then displays the name of the service corresponding to the code (up to 20 characters) and asks the provider to verify that this is indeed the ser- vice that was provided. If the provider has entered a nonexistent code, an error message is printed. The provider also can enter comments about the service provided. The software product now writes a record to disk that includes the following elds: Current date and time (MM–DD–YYYY HH:MM:SS). Date service was provided (MM–DD–YYYY). Provider number (9 digits). Member number (9 digits). Service code (6 digits). Comments (100 characters) (optional). The software product next looks up the fee to be paid for that service and displays it on the provider’s terminal. For veri cation purposes, the provider has a form on which to enter the current date and time, the date the service was provided, member name and number, service code, and fee to be paid. At the end of the week, the provider totals the fees to verify the amount to be paid to that provider by ChocAn for that week. At any time, a provider can request the software product for a Provider Directory, an alphabetically ordered list of service names and corresponding service codes and fees. The Provider Directory is sent to the provider as an e-mail attachment. At midnight on Friday, the main accounting procedure is run at the ChocAn Data Center. It reads the week’s le of services provided and prints a number of reports. Each report also can be run individually at the request of a ChocAn manager at any time during the week. Each member who has consulted a ChocAn provider during that week receives a list of services provided to that member, sorted in order of service date. The report, which is also sent as an e-mail attachment, includes: Member name (25 characters). Member number (9 digits). Member street address (25 characters). Member city (14 characters). Member state (2 letters). Member ZIP code (5 digits). For each service provided, the following details are required: Date of service (MM–DD–YYYY). Provider name (25 characters). Service name (20 characters). Each provider who has billed ChocAn during that week receives a report, sent as an e-mail attachment, containing the list of services he or she provided to ChocAn members. To simplify the task of veri cation, the report contains the same information as that entered on the provider’s form, in the order that the data were received by the computer. At the end of the report is a summary including the number of consultations with members and the total fee for that week. That is, the elds of the report include: sch76183_appA_627-629.indd 628 sch76183_appA_627-629.indd 628 07/06/10 11:53 AM 07/06/10 11:53 AM Appendix A Term Project: Chocoholics Anonymous 629 Provider name (25 characters). Provider number (9 digits). Provider street address (25 characters). Provider city (14 characters). Provider state (2 letters). Provider ZIP code (5 digits). For each service provided, the following details are required: Date of service (MM–DD–YYYY). Date and time data were received by the computer (MM–DD–YYYY HH:MM:SS). Member name (25 characters). Member number (9 digits). Service code (6 digits). Fee to be paid (up to $999.99). Total number of consultations with members (3 digits). Total fee for week (up to $99,999.99). A record consisting of electronic funds transfer (EFT) data is then wr itten to a disk; banking computers will later ensure that each provider’s bank account is credited with the appropriate amount. A summary report is given to the manager for accounts payable. The report lists every provider to be paid that week, the number of consultations each had, and his or her total fee for that week. Finally, the total number of providers who provided services, the total number of consultations, and the overall fee total are printed. During the day, the software at the ChocAn Data Center is run in interactive mode to allow operators to add new members to ChocAn, to delete members who have resigned, and to update member records. Similarly, provider records are added, deleted, and updated. The processing of payments of ChocAn membership fees has been contracted out to Acme Accounting Services, a third-party organization. Acme is responsible for nancial procedures such as recording payments of membership fees, suspending members whose fees are overdue, and reinstating suspended members who have now paid what is owing. The Acme computer updates the relevant ChocAn Data Center computer membership records each evening at 9 P.M. Your organization has been awarded the contract to write only the ChocAn data process- ing software; another organization will be responsible for the communications software, for designing the ChocAn provider’s terminal, for the software needed by Acme Account- ing Services, and for implementing the EFT component. The contract states that, at the acceptance test, the data from a provider’s terminal must be simulated by keyboard input and data to be transmitted to a provider’s terminal display must appear on the screen. A manager’s terminal must be simulated by the same keyboard and screen. Each member report must be written to its own le; the name of the le should begin with the member name, followed by the date of the report. The provider reports should be handled the same way. The Provider Directory must also be created as a le. None of the les should actually be sent as e-mail attachments. As for the EFT data, all that is required is that a le be set up containing the provider name, provider number, and the amount to be transferred. sch76183_appA_627-629.indd 629 sch76183_appA_627-629.indd 629 07/06/10 11:53 AM 07/06/10 11:53 AM