Need help Asap answering the attachment provided. Please look into

Jillian's Candy Emporium Purchasing Cycle Assignment Project -- Phase I Requirements (worth up to 6 points towards final grade): o Based on the narrative below, your team should follow steps 1-7 of the event oriented modeling construct for EER (or REA) and DFD diagrams. The result will be a logical data model and process model for Jillian's Candy Emporium purchasing cycle o Remember, the first 6 steps define how to create the EER diagram and the 7th step defines the DFD. The DFD diagrams should include a context diagram and Level 0 DFD and should include all business processes identified in the narrative. Don't forget to include maintenance and reporting DFD's if appropriate. Each team should submit the following o An MS Word document describing in detail each one of the 7 steps as they apply to this case. This should be similar to the Student Registration System example in the PowerPoint for Chapter 8. Completed EER (or REA) and DFD diagrams for Jillian's Candy Emporium. You may want to use a free trial version of an online diagramming tool (one choice is at http://www.gliffy.com/ ) or any other drawing program of your choice that allows you to export your diagrams into a commonly readable format. It is perfectly fine to use Microsoft Excel to draw your solutions. To get full credit, the solution must be complete and correct (especially cardinality). If you identify more resources/events/agents than needed (within reason), no points will be deducted! Your product should be easily understandable by a third party, as if you expect to hand off your specifications to a new project team to complete physical design and implementation. o All team members are required to participate equally and should expect to be called upon to present any part of the project. o A hard copy of Phase I of the project is due by the start of class on November 2, 2015 (subject to change - in either direction) Strong word of advice - Do not wait until the last minute! You will have learned how to do this work well before the due date, so you will risk forgetting the key concepts. Narrative: Jillian Rodriguez is the owner and operator of a specialty candy provider, Jillian's Candy Emporium. She has decided to develop a new database system to track her purchases, candy inventory, accounts payable, and cash payments. However, she does not have time to do the development herself. Therefore, she has hired you to design and implement the system for her. She describes the requirements of her purchasing system as follows: Whenever candies are needed, a purchasing agent enters a purchase order for the items needed directly into the computer system. To accommodate all of her candy needs, the purchasing agent may need to prepare several orders, as Jillian orders candies from many different vendors. The purchasing agent may order several types of candies from a single vendor on one order. Jillian approves and prints these purchase orders and sends them to the vendors. A data entry clerk records the receipt of candy from a vendor on a special screen in the accounting system. At the end of each month, an accounts payable clerk creates checks to pay for all amounts charged through the end of the month. Once the checks are created, Jillian authorizes the checks, prints them, and mails them to vendors. Jillian also uses special screens in the computer system to perform maintenance for inventory items (add, modify and delete items), and to record the disposal of spoiled or damaged candies. Prepare an ER diagram describing Jillian's database. An REA format is quite appropriate for this Accounting System if you would prefer to design with it. You may repeat a box for an individual entity if necessary to make your drawing neat. Jillian would like you to consider that, eventually, as her business grows, she will have managers perform the tasks she now performs. As a result, the system should be planned to always store information about the employees associated with transactions, whether the employees enter information, performs a task (such as delivery) or formally authorize the transaction. Prepare the context diagram and the level 0 DFD. Hints: (1) Each item on a receipt may be from a purchase order. Different items on a single purchase order may be received at different times using different receipts. (2) Each check may pay for several receipts. However, a single receipt will always be paid for using the same check. (3) Multiple candies may be disposed of using a single form. Jillian's Candy Emporium Purchasing Cycle Assignment Project -- Phase I Requirements (worth up to 6 points towards final grade): o Based on the narrative below, your team should follow steps 1-7 of the event oriented modeling construct for EER (or REA) and DFD diagrams. The result will be a logical data model and process model for Jillian's Candy Emporium purchasing cycle o Remember, the first 6 steps define how to create the EER diagram and the 7th step defines the DFD. The DFD diagrams should include a context diagram and Level 0 DFD and should include all business processes identified in the narrative. Don't forget to include maintenance and reporting DFD's if appropriate. Each team should submit the following o An MS Word document describing in detail each one of the 7 steps as they apply to this case. This should be similar to the Student Registration System example in the PowerPoint for Chapter 8. Completed EER (or REA) and DFD diagrams for Jillian's Candy Emporium. You may want to use a free trial version of an online diagramming tool (one choice is at http://www.gliffy.com/ ) or any other drawing program of your choice that allows you to export your diagrams into a commonly readable format. It is perfectly fine to use Microsoft Excel to draw your solutions. To get full credit, the solution must be complete and correct (especially cardinality). If you identify more resources/events/agents than needed (within reason), no points will be deducted! Your product should be easily understandable by a third party, as if you expect to hand off your specifications to a new project team to complete physical design and implementation. o All team members are required to participate equally and should expect to be called upon to present any part of the project. o A hard copy of Phase I of the project is due by the start of class on November 2, 2015 (subject to change - in either direction) Strong word of advice - Do not wait until the last minute! You will have learned how to do this work well before the due date, so you will risk forgetting the key concepts. Narrative: Jillian Rodriguez is the owner and operator of a specialty candy provider, Jillian's Candy Emporium. She has decided to develop a new database system to track her purchases, candy inventory, accounts payable, and cash payments. However, she does not have time to do the development herself. Therefore, she has hired you to design and implement the system for her. She describes the requirements of her purchasing system as follows: Whenever candies are needed, a purchasing agent enters a purchase order for the items needed directly into the computer system. To accommodate all of her candy needs, the purchasing agent may need to prepare several orders, as Jillian orders candies from many different vendors. The purchasing agent may order several types of candies from a single vendor on one order. Jillian approves and prints these purchase orders and sends them to the vendors. A data entry clerk records the receipt of candy from a vendor on a special screen in the accounting system. At the end of each month, an accounts payable clerk creates checks to pay for all amounts charged through the end of the month. Once the checks are created, Jillian authorizes the checks, prints them, and mails them to vendors. Jillian also uses special screens in the computer system to perform maintenance for inventory items (add, modify and delete items), and to record the disposal of spoiled or damaged candies. Prepare an ER diagram describing Jillian's database. An REA format is quite appropriate for this Accounting System if you would prefer to design with it. You may repeat a box for an individual entity if necessary to make your drawing neat. Jillian would like you to consider that, eventually, as her business grows, she will have managers perform the tasks she now performs. As a result, the system should be planned to always store information about the employees associated with transactions, whether the employees enter information, performs a task (such as delivery) or formally authorize the transaction. Prepare the context diagram and the level 0 DFD. Hints: (1) Each item on a receipt may be from a purchase order. Different items on a single purchase order may be received at different times using different receipts. (2) Each check may pay for several receipts. However, a single receipt will always be paid for using the same check. (3) Multiple candies may be disposed of using a single form