Case Assignment: Data and Process Modeling Before You Begin - Assignment Specific Based on prior requirements gathering, you are now ready to make logical models for the new system. This phase is essential to understand the data and decision processes in the new system. During this stage, you will make data flow diagrams (DFDs), decision tables, and decision trees. ? -In this simulation environment, you will review the emails which contain instructions for this case assignment. Complete the following: 1. Make a DFD-Context Diagram identifying all the processes and the entities with at least 1 inflow and 1 outflow into each entity. 2. Makea Decision Table 3. Makea Simplified Table 4. Makea Decision Tree

ALL RELAVENT INFORMATION + more instructions are in the IMAGES. Please look at the email images for details. JAD session and staffing are also provided just in case it is needed (Staffing may not even be needed).

(Please do not say missing information because this is all I can provide)

Instructions are within the "Complete the following" section above, and there are more instructions within the email images below.

-In this simulation environment, you will review the emails which contain instructions for this case assignment.

Appliance Warehouse Webmail Client Resource Library Template Library Company Website ? GP Q Search Diagrams + New Message Carlie Davis July 18, 2022 ) 7 : Carlie Davis Jul 20 Decision tree Inbox Nice work on the decision table!.. Hi G, Flagged Carlie Davis Jul 19 Sent Thanks for the great information gathered through your interviews and questionnaires! Appliance Service plan Changes Hopefully, you are at the point that you can envision how this new system will Drafts Hopefully, you are not too bogged down function. with the DFD.. Deleted You should create a Data Flow Diagram (DFD). This diagram will help the programmers Spam Carlie Davis Jul 18 understand how information is flowing through the proposed system. I suggest that Diagrams you use the notes from the JAD session. They have identified the entities and Thanks for the great information gathered processes and you can use this information to create a context diagram. through. Folders Please have this done by our next meeting. + New Folder Carlie P.S. Mae named our new system "SIM", short for "Service Information Management", and everyone loves the name. Let's call this new system "SIM" for now on.llAD session excerpts Alan Marks [store mgr]: I am so excited to be launching this new service to our customers! It's going to be great to not have to refer out customers to unknown service companies. Besides. ifthey can't fix their own appliance, we might be able to convince them to visit the store to replace it. Emily Johns [service manager}: Yes, I agree! We need to work very closely with the parts department in order to get the service estimates out to the customer and get the parts for the repair quickly. Meredith Parks {programmer}: I think it would be a good idea to name our new service system. Any ideas? Man Marks {store mgr]: Service Information System? SIS? EmilyJohns [service manager}: Service Information Manager? SIM? Meredith Parkslprogrammer]: OK, let's vote. Meredith conducts a quick note and at! are agreed on SIM. Maddox Farley [parts director]: i'm a little worried about how this SIM will affect my inventory levels. Meredith Parks {programmer}: I need you to break this down a bit for me. Who is involved in this new process? Emily Johns [service manager]: We definitely have the customers, parts departmentl partsy technicians. appointment setters. and calendar. Meredith Parks tprogrammer]: OK, now we have our entities. What are the processes that will take place? Alan Marks {store mgr]: Well, we will need to generate estimates and final invoices. Emily Johns [service manager}: Flight. And we'll make appointments. order parts, assign technicians to appointments. Meredith Parks (programmer): Anything else? Emily Johns {service manager}: A calendar shouEd be able to be viewed or printed for each technician. Each technician needs their daily schedule of appointments at the beginning of each day. Alan Marks {store mgr]: I don't think so. Payment will be accepted by the current cashier's system. Meredith Parks {programmer}: OK. Appliance Warehouse Webmail Client Resource Library Template Library Company Website ? GP Q. Search Appliance Service plan Changes + New Message Carlie Davis July 19. 2022 17 : Carlie Davis Jul 20 Decision tree Inbox Nice work on the decision table!... Hi G, Flagged Carlie Davis Jul 19 Hopefully, you are not too bogged down with the DFD. The owner and store manager Sent Appliance Service plan Changes met this morning and came up with some new rules that will need to be implemented Drafts Hopefully. you are not too bogged down in the SIM system: with the DFD. Deleted The owner and store manager have decided to offer customers a service plan Spam Carlie Davis Jul 18 were they pay a flat rate once a year. With this plan, customers only pay for the Diagrams cost of parts when they have their appliance(s) serviced. They can only buy a Thanks for the great information gathered service plan if they have purchased an appliance from Appliance Warehouse. Folders through.. With this new service plan, if they have service on their appliance more than 3 + New Folder times during the year, they will have to pay the full amount of the service fee and cost of parts. o If the customer does not buy a service plan but buys their appliance from us, we will give a 20% discount off the service fee for the life of their appliance. o Everyone else will pay the full cost of the service plan and parts cost. Create a decision table from these rules. I would like to see your first pass at this by our next scheduled meeting. Thanks!Appliance Warehouse Webmail Client Resource Library Template Library Company Website ? GP Q Search Decision tree + New Message Carlie Davis July 20, 2022 ) 7 : Carlie Davis Jul 20 Decision tree Inbox Nice work on the decision table!. Hi G, Flagged Carlie Davis Jul 19 Nice work on the decision table! Now you'll need to simplify the decision table so that Sent Appliance Service plan Changes you can create a decision tree. The programmers find it very helpful to have all the Drafts Hopefully, you are not too bogged down decisions laid out in a decision tree. with the DFD.. Deleted Please have these done by the end of the week. Spam Carlie Davis Jul 18 Diagrams Carlie Thanks for the great information gathered through. Folders + New Folder Forward Reply NowAppliance Warehouse staffing Parts Department - purchasing, inventory control, sales . Director: Maddox Farley Sales staff: Tyler Cummings, Steve Dawson, Amelia Warner . Purchasing: Celia Martel, Joe Perez . Inventory/warehouse: Ben Cooke, Melissa Benedict, Matt Jones Appliance Sales - sales of new appliances in 4 departments Director: Sonia Lopez Large Kitchen Appliance department: Mike Nelson (manager), Jessica Scott, Rachel Evans, Justin Cooper Laundry Appliance department: Tina Turner (manager), Mackenzie Scott, James Wright Audio/Visual department: Samantha Campbell (manager), Tim Reynolds, Tracey Oliver Small Appliance department: Peter Parker (manager), Ken Howell, Marti Castillo Service Department Service Manager: Emily Johns Technicians: Liam Henson, Mark Robles, Lee Wong Appointment setters: Lisa Shields, Jake Meyers Equipment and parts: Rhonda Patel Storewide Cashiers: Manager: Abby Franklin Cashiers: Nancy Richards, Joy Vasquez, David Goodman, Paul Patton, Maria Nunez Administrative roles: . Owner (store manager reports to this role): Mae Roth . Store Manager (all department heads and assistant manager report to this role): Alan Marks Store Assistant Manager (admin roles report to this assistant manager): Ali Miranda Admin Assistant to store manager: Tim Stafford Human Resources specialist: Joey Booker Accounting, payroll, accounts payable/receivable: Doug Dorsey, Tia Carey IT department: Carlie Davis (manager), Tony Barlett, Meredith Parks, youService Records Sample Date Date of Appliance type Appliance serial Parts Technician Customer Name Customer Address Customer Phone Called Service number Needed assigned 1/6 1/6 Refrigerator KN-78-215-896 KN-1256 Robles Sophie Goldberg 123 Main St, Hopkinton, MA 508-555-1256 1/6 1/7 Dishwasher WP-55-311-698 WP-1788 Wong Mitch Chu 5525 Winter Rd, Medford, MA 617-555-9898 1/7 1/7 Refrigerator WP-78-956-694 WP-8877 Henson Jamie Fernandez 2 Hope St, Hull, MA 617-555-4125 1/8 1/10 Microwave AB-99-357-753 AB-3321 Wong Mike Singh 15 Arch St, Tewksbury, MA 508-555-3596 1/9 1/9 Washing machine GE-10-122-542 GE-2119 Robles George Kostanza 369 Pike Circle, Danvers, MA 508-555-6235 1/9 1/10 Dishwasher KN-55-396-477 KN-5511 Robles Felicia Parkinson 50 Central Ave, Hopedale, MA 508-555-2144Questionnaire results Results are ordered by importance. The top result (#1) is the most important to that group. Most common features requested by appointment setters: . Reminder services calls/messages See technician's availability Determination of discounts for customers See availability of parts to schedule repair View service history Most common features requested by technicians: * Able to view own calendar See availability of parts to schedule repair Keep notes for each customer Mobile access of scheduling View service history Reminder services calls/messages Most common features requested by parts department: . Can pull inventory requests every two hours. . Database of requested parts. Most common features requested by management: * Reporting by time period, type of appliance, brand . Determination of discounts for customers Mobile access of scheduling Routing and mapping of technician's driving to appointments See technician's availability Suggest preventative maintenance to customersCosts for in-house development Standard Development Times As standard practice, use these costs As standard practice, use these guidelines (assume & for all in-house development. hours of work per day). Cost per hour (for first year) Duration Database Development 60 Database design 5 days Web developers 75 Database build 10 days App developers 75 Design of a report (web or app) 2 days UX designers 60 Design of data entry page (web or app) 2 days Business Analyst 50 Design of static text page (web or app) 1 day Trainers 50 Build of a report (web or app) 1 day Cybersecurity specialists 90 Build of data entry page (web or app) 1 day System Admin 70 Build of static text page (web or app) 1 day Connection to separate system or database (sys admin) 8 days Analysis work (both web and app combined) 20 days Training 5 days Equipment: Cybersecurity work 10 days Servers 2,500 Routers 200 Expected Monthly Maintenance: Development (web or app) 2 days System Admin 3 days Training 1 dayAnalysis and Design task durations Project name Year Task name Duration Accounts Payable 2018 Interview process 5 days Development of User Questionnaire 2 days Identification of risks 1.5 days DFD diagram 4 days UML diagram 4 days Layout of 1 report 4 hours Layout of 1 user screen 2 hours Testing plan 5 days Implementation plan 3 days Human Resources 2017 Interview process 4 days Development of User Questionnaire 2 days Identification of risks 1 day DFD diagram 3.5 days UML diagram 2 days Layout of 1 report 2 hours Layout of 1 user screen 4 hours Testing plan 7 days Implementation plan 3 days Payroll 2019 Interview process 6 days Development of User Questionnaire 1 day Identification of risks 2 days DFD diagram 4.5 days UML diagram 5 days Layout of 1 report 1 day Layout of 1 user screen 4 hours Testing plan 5 days Implementation plan 3.5 days