Please anyone can help me with this assignment, It'd be great if it can be done in Excel, thank you so much in advance.

Below are 3 business scenarios For each scenario please create: 1. the context data flow diagram (DFD), 2. the Level 0 logical view data flow diagram, 3. the physical view diagram DFD The context diagram is like a table of content in a book. It provides a high level overview of the model. Level 0 DFD's are more detailed. They are created in pairs. The Physical View Level 0 DFD answers the question "who does the work". The Logical View Level 0 DFD answers the question "what work gets done". Please be sure to follow the rules for documenting business processes using dataflow diagrams: - The process begins and ends with an agent that is external to the process. Agents are identified by boxes. Examples of Agents are Customers, Vendors etc. - For Logical View Level 0 DFD's processes are represented by bubbles. Processes should be identified using action words. An example of a process may be Invoice Processing. -For Physical View Level 0 DFD's job positions are represented by bubbles. Positions may include accountants, inside sales, credit managers, etc. -Flows are represented using arrows. The arrows should be labelled with identifiers that indicate the information that is flowing. Action words are not used to label the arrows. No two arrows should have the same label. - Storage is represented by a double line. Flows into storage or in and out of storage may be labeled however, if the storage label makes it obvious as to what information is moving in and out of storage the flows do not need to be labelled. - Context diagrams to not show storage. -Time is not represented on the data flow diagrams. -DFD's are created to document the flow of information within your company so always prepare them from the perspective of your organization. -Process bubbles are numbered with 1.0, 2.0 etc. in the logical and physical view Level 0 diagrams 1.Business Situation: A recruitment company regularly sends your company resumes for potential candidates. A clerk sorts the resumes by the expertise of the candidate. An HR analyst assigns candidates to the specific job positions available. The clerk forwards the resumes to the hiring managers for review. A short list of candidates for interviews is returned by each hiring manager to the clerk and the HR analyst contacts the candidates for interviews. 2.Business Situation: An invoice is received in your company. The mail clerk scans the invoice into the computer system and cancels the invoice by stamping it with the date received and processed. The indexing clerk indexes the invoice to ensure the scanned invoice was read correctly by the computer system so the purchase order, the vendor, and the total invoice amount are correctly identified. The invoice is then released into the computer workflow. The invoice processing clerks in the accounts payable department check the workflow and process the invoices against the appropriate purchase orders by ensuring the goods receipts have been completed by the receiving department. The accounts payable payment specialist pays the vendor with a wire transfer, after it is approved by two managers, for the quantity of product received. 3.Business Situation: A customer orders three different products from your company over the internet. As the customer is new to the company, they must complete customer information on the company website. They also must indicate they have read the company privacy policy assuring them their personal information will be kept safe. Prior to payment, the computer system verifies that the inventory is available and estimates the date the customer will receive their product. Once the customer confirms that the shipping time is acceptable they pay with a credit card. The order is then send via computer workflow to the most appropriate warehouse to minimize shipping costs to the customer. The shipping clerk receives the workflow and packages the product. The packaged product has a bill of lading attached to the outside of the package and the package is released to the shipping company by scanning it onto their truck. When the packages are scanned inventory is relieved from the computer system.