Kims Flower Shop Purchasing Cycle

Requirements:

• Based on the narrative below, your team should follow steps 1-7 of the event oriented modeling (covered in chapter 8) for constructing EER and DFD diagrams.
• Your team should submit completed EER and DFD diagrams for Kims Flowers. You may want to use a free trial version of the online diagramming tool http://www.gliffy.com/ or any other drawing program of your choice that allows you to export your diagrams in a commonly readable format. Another possible option is a freely available Dia: http://dia-installer.de/index_en.html Or you can use MS-Excel.
• If you identify more resources/events/agents than needed, NO points will be deducted.
• All students are required to equally participate in the project and may be called upon to present any part of the project.

Kim Burke is the owner and operator of a small flower shop, Kim's Flowers. She has decided to develop a database system to track her purchases, floral inventory, accounts payable and cash payments. However, she does not have time to do the development herself. Therefore, she asked you to design and implement the system for her. She describes the requirements of her system as follows:

She hired purchasing agents, floral designers, and accounts payable clerks for her business. Whenever flowers are needed, a purchasing agent enters a purchase order for the items needed directly into the computer system. To accommodate all of her floral needs, the purchasing agent may need to prepare several orders, as Kim orders flowers from many different vendors. The purchasing agent may order several types of flowers from a single vendor on one order. Kim approves and prints these purchase orders and sends them to the vendors. A floral designer records the receipt of flowers from a vendor on a special screen in her 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, Kim authorizes the checks, prints them and mails them to vendors. Kim 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 the disposal of old or damaged flowers.

• Prepare an EER diagram describing Kim's database. You may repeat a box for an individual entity if necessary to make your drawing neat. Kim 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. Hints: (1) Items on a floral receipt may be from different purchase orders. 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 floral items may be disposed of using a single form. (4) For simplicity, each store will use a separate system, even if Kim may open new stores in the future. Each system of each store will contain information which is only related to one store.
• Prepare the context diagram and the level 0 DFD.
• If the above description is not clear or enough, add your own assumptions and build your EER and DFD based on those added assumptions.
• In your EER, you can omit the detail attribute names. However, specify the cardinality and optionality in your EER. (You can leave the detail attributes in your EER, it will be helpful for the stage 2 and 3 of this project.)
• Submit one single file. If you have multiple image files, you can include all of them in your one single MS-Word or MS-Excel file.