Johns Flowers Expenditure Cycle

John has decided to develop a database system to track his purchases, floral inventory, accounts payable and cash payments. However, he does not have time to do the development himself. Therefore, he has hired you to design and implement the system for his. He describes the requirements of his system as follows:

Whenever flowers are needed, a purchasing agent enters a purchase order for the items needed directly into the computer system. To accommodate all of his floral needs, the purchasing agent may need to prepare several orders, as John orders flowers from many different vendors. Vendors are selected based on information maintained about their delivery performance and prices for floral 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 the 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. John approves and prints these purchase orders and sends them to the vendors. A floral designer records the receipts of flowers from a vendor on a special screen in his 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 createdm John authorizes the checks, prints them and mails them to vendors. John also uses special screens in the computer system to perform maintenance for inventory items (add, modify and delete items from the file), and to record disposal of old or damaged flowers.

Prepare an ER diagram describing Johns database. You may repeat a box for an individual entity if necessary to make your drawing neat. John would like for you to consider that, eventually, as new stores are opened, he will have store managers in each store that will perform the tasks he 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. Hints: (1) Each item on a floral receipt may be from a diffenrent purchase order. Different items on a single purchase order may be received at different times using different receipts. (2) Cash payments are tracked to a specific purchase order. Each check may pay for several orders. However, a single order will always be paid for using the same check. (3) Multiple floral items may be disposed of using a single form.

List and describe all of the recordingm maintenance and reporting information processes described in the narrative.

Convert the ER Diagram for Johns Flowers Expenditure cycle to database tables using the conversion rules.