ERD forRevenue cycle(Please find the development of this ERD in the Panopto recorded lectures.) and the schema for Revenue cycle.All must be prepared withwww.draw.io(for the diagrams) and Microsoft Word or Excel (for the written part).You may submit one single file or two separate files in PDF format.
- ERD forExpenditure cycleand the schema for Expenditure cycle.Same submission requirement as above.
- Combine ERD for Revenue cycle and Expenditure cycle.You use the common entities (i.e., Employee, Item, and Bank_Account) to join the two ERDs.Same submission requirement as above.
Sue's Flowers Expenditure Cycle P ' be com leted and subm't ed ents Now that you have helped Sue develop the ERD for the Revenue Cycle, Sue has decided to develop a database system to track her purchases, oral inventory, accounts payable and cash payments. However, she does not have time to do the development herself. Therefore, she has lured you to design and implement the system for her. She describes the requirements of her expenditure system as follows: Whenever owers are needed, a purchasing agent enters a purchase order for the items directly into the computer system. To accommodate all of her oral needs, the purchasing agent may need to prepare several orders, as Sue orders owers from many different vendors. Vendors are selected based on information maintained about their delivery performance and prices for oral items they are approved to sell. This information is maintained by a special purchasing clerk who gets catalogs and other materials from vendors and enters the data into the system using a special screen. The purchasing agent views this information using a special inquiry screen within the computer system. The purchasing agent may order several types of flowers from a single vendor on one order. Sue approves and prints these purchase orders and sends them to the vendors. A oral designer records the receipt of flowers from a vendor on a special screen in this 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, Sue authorizes the checks, prints them and mails them to Vendors. Sue also uses special screens in the computer system to perform maintenance for inventory items (add, modify and delete items from the le), and to record disposal of old or damaged owers. 1- Prepare an ER diagram describing Sue's database. You may repeat a box for an individual entity if necessary to make your drawing neat. Sue would like for you to consider that, eventually, as new stores are opened, she will have store managers in each store that will perform the tasks she now performs. As a result, the system should be planned to always store information about the employee associated with transactions, whether that employee enters information, performs a task (such as delivery) or formally authorizes the transaction. 0 Hints: 0 Each item on a oral receipt. may be from a different purchase order. Different items on a single purchase order may be received at different times using different receipts. 0 Cash payments are tracked to a specic pmchase order. Each check may pay for several orders. However, a single order will always be paid for using the same check 0 Multiple oral items may be disposed of using a single form- Convert the ER Diagram for Sue's Flowers' Expenditure cycle to database tables using conversion rules covered. in class. Aci- you nish all the steps above, merge this Expenditure ERD with the ERD for Sue's Flowers Revenue Cycle developed in class
