Question

Kim Burke is the owner and operator of a small flower shop, Kim's Flowers. She has...

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 has hired you to design and implement the system for her. She describes the requirements of her 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 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 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) Each item on a floral receipt may be from a different 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 floral items may be disposed of using a single form Prepare the context diagram and the level 0 DFD

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer: Given Hints on (l9 Each item on a floral se ceipt may be from a different purchase order, Different items on a SinglFloral Shop: Context diagram and the level o DED Reviews checks Purchase Order kim opprove checks n Goods Supply Mail 0.0 flo

Add a comment
Know the answer?
Add Answer to:
Kim Burke is the owner and operator of a small flower shop, Kim's Flowers. She has...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • How would I start to solve this problem? Sue's Flowers Revenue Business Process Project Hernandez is...

    How would I start to solve this problem? Sue's Flowers Revenue Business Process Project Hernandez is the owner and operator of a Sue develop a database system to track her sales, inventory, accounts system is used for large orders that are small flower shop, Sue's Flowers. She has decided to receivable and cash receipts. This arranged in advance. However, she does not have time to do the development herself. Therefore, she has hired you to design and implement the system...

  • 3.4 Beccan Company is a discount tine dealer operating 25 retail stores in a large metro...

    3.4 Beccan Company is a discount tine dealer operating 25 retail stores in a large metro politan area. The company purchases all tires and related supplies using the company's central purchasing department to optimize quantity discounts. The tires and supplies are received at the central warehouse and distributed to the retail stores as needed. The perpetual inventory system at the central facility maintains current inventory records, designated reorder points, and optimum order quantities for each type and size of time...

  • Help with this problem, please. Conceptual Model: Draw an REA model with cardinalities for the operating...

    Help with this problem, please. Conceptual Model: Draw an REA model with cardinalities for the operating events, resources, and agents in the Formula One inventory acquisition/payment process. Please be sure to include cardinalities with your relationships on the relationship lines, similar to the additional attachment I'm including, thank you for all help. Please keep the resource entities on the left, and the agents on the right-hand side, with the events in the middle if you can use the additional attachment...

  • Formula One Formula one sells auto parts at fourteen stores in Northern Virginia and Washington, DC....

    Formula One Formula one sells auto parts at fourteen stores in Northern Virginia and Washington, DC. The following describes the business processes Formula One uses for the acquisition of inventory items. Formula One has a purchasing department centrally located at company headquarters in Burke, VA. The acquisition/payment process begins when a store manager determines a need for inventory at his/her location. The manager enters the requested items directly into the ERP system to generate a purchase requisition form. A purchasing...

  • A purchasing clerk at corporate headquarters checks the system for open requests. Based on the sy...

    A purchasing clerk at corporate headquarters checks the system for open requests. Based on the system’s purchase requisitions, the purchasing clerk prepares each purchase order using the ERP system. A request may need to be split into more than one order as not all vendors supply every item. To obtain volume discounts, the clerk combines all requests for similar items into one purchase order. Each purchase order instructs the vendor to ship the inventory items directly to the appropriate stores....

  • Help with this problem, please. Conceptual Model: Draw an REA model with cardinalities for the operating...

    Help with this problem, please. Conceptual Model: Draw an REA model with cardinalities for the operating events, resources, and agents in the Formula One inventory acquisition/payment process. Please be sure to include cardinalities with your relationships, thank you. Formula One Formula one sells auto parts at fourteen stores in Northern Virginia and Washington, DC. The following describes the business processes Formula One uses for the acquisition of inventory items. Formula One has a purchasing department centrally located at company headquarters...

  • Kim Jungemann, owner of Tulip Time, operates a local chain of floral shops Each shop has...

    Kim Jungemann, owner of Tulip Time, operates a local chain of floral shops Each shop has its own delivery van instead of charging a flat delivery foe, Jungemann wants to set the delivery fee based on the distance driven to deliver the flowers. Jungemann wants to separate the foxed and variable portions of her van operating costs so that she has a better idea how delivery distance affects these costs. She has the following data from the past seven months...

  • I need some help with to create the REA model and how textual information is converted...

    I need some help with to create the REA model and how textual information is converted into an REA model.You get some description of the firm's expenditure cycle, and are asked to create the REA model. Formula one sells auto parts at fourteen stores in Northern Virginia and Washington, DC. The following describes the business processes Formula One uses for the acquisition of inventory items. Formula One has a purchasing department centrally located at company headquarters in Burke, VA. The...

  • Formula One Formula one sells auto parts at fourteen stores in Northern Virginia and Washington, DC....

    Formula One Formula one sells auto parts at fourteen stores in Northern Virginia and Washington, DC. The. following describes the business processes Formula One uses for the acquisition of Inventory items. Formula One has a purchasing department centrally located at company headquarters in Burke, VA. The acquisition/payment process begins when a store manager determines a need for inventory at his/her location. The manager enters the requested items directly into the ERP system to generate a purchase requisition form. A purchasing...

  • Formula One Formula one sells auto parts at fourteen stores in Northern Virginia and Washington, DC....

    Formula One Formula one sells auto parts at fourteen stores in Northern Virginia and Washington, DC. The following describes the business processes Formula One uses for the acquisition of inventory items. Formula One has a purchasing department centrally located at company headquarters in Burke, VA. The acquisition/payment process begins when a store manager determines a need for inventory at his/her location. The manager enters the requested items directly into the ERP system to generate a purchase requisition form. A purchasing...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT