Put together an rea diagram describing kim flower inc
Group Undertaking – Kim’s Flower Inc. Buying (Expenditure) Cycle
Background:
Kim’s Flower Inc. is operated by Kim Burke, the Chief Government Officer (CEO), and her related staff. She has determined to develop a database system to trace her purchases, floral stock, accounts payable, and money funds. Nevertheless, she doesn’t have time to do the event herself. Due to this fact, she has employed you and your crew members to design and implement the system (i.e., flower buying system) for her. She describes the necessities of her system as follows:
Each time flowers are wanted, a buying clerk prepares a purchase order order by finishing a purchase order order kind. The acquisition order kind consists of buy order quantity, order date, merchandise quantity, amount ordered, order value, worker quantity (preparer), worker quantity (authorizer), and vendor quantity. To accommodate all of floral wants, the buying clerk may have to organize a number of buy orders, as Kim’s Flower Inc. orders flowers from a number of distributors. Additionally, a purchase order order could be made for a number of forms of flowers from a single vendor. When the acquisition order kind is ready, the buying clerk forwards the shape to the CEO, Kim Burke, who approves the order. The permitted buy order then sends to a vendor.
Then the seller will ship the flowers within the order. When the order is acquired, a warehouse division clerk inspects the standard of flowers and verifies the amount of flowers primarily based on the acquisition order and the packing slip included within the cargo. The clerk then prepares a receiving report, forwards the report back to an accounting payable clerk for fee course of, and updates stock data. The receiving report consists of receipt quantity, receipt date, amount acquired, merchandise situation, buy order quantity, worker quantity (receiver), and vendor quantity. Additionally, an bill is delivered to the accounts payable clerk from the seller.
On the finish of every month, the accounts payable clerk put together an buy order fee kind for all quantities charged by the top of the month by verifying invoices, buy orders, and receiving experiences. The acquisition order fee kind consists of fee quantity, fee date, fee quantity, worker quantity (preparer), worker quantity (authorizer), receipt quantity, vendor quantity, and account quantity. The shape is then forwarded to the CEO. When the CEO authorizes the fee kind, the accounts payable clerk prepares a verify and mails it to the seller. Lastly, a month-to-month abstract report of buy orders and funds is ready for every month and forwarded to the CEO.
(Word: If the enterprise guidelines will not be clear, use typical cardinalities.)
Duties:
1. Put together an REA diagram describing Kim’s Flower Inc.’s database. You might repeat a field for a person entity if essential to make your drawing neat. Kim would love so that you can take into account that, finally, as new shops are opened, she may have retailer managers in every retailer that may carry out the duties she now performs. In consequence, the system must be deliberate to at all times retailer details about the worker related to transactions, whether or not that worker enters data, performs a process (similar to supply) or formally authorizes the transaction.
Hints:
(1) Every merchandise on a floral receipt could also be from totally different buy orders. Totally different gadgets on a single buy order could also be acquired at totally different instances utilizing totally different receipts.
(2) Every verify could pay for a number of receipts. Nevertheless, a single receipt will at all times be paid for utilizing the identical verify.
2. Put together the context diagram and the extent Zero DFD.
1) Context Diagram
Trace: Supply/Vacation spot – CEO, Buying Clerk, Vendor, Warehouse Clerk
2) Stage-Zero DFD
Hints: Foremost features – 1) Obtain Buy Order, 2) Obtain Order, three) Make Fee, and four) Generate Report
Information Retailer – Buy Order, Flower Stock, Vendor, Money
three. For the record of attributes for every entity, full the desk under. Use underline to point the identifier of every entity.
Entity | Attributes |
Flower Stock | , Description, QtyOnHand, ListPrice |
Vendor | , VendorName, VendorAddress, Steadiness |
Worker | , EmployeeName, EmployeeAddress, DateStarted, JobTitle, Cellphone |
Money | ,AccountType, Financial institution, AccountBalance |