Given the following narrative description for Tina's Toy Factory (TTF):
a. Create a business process level REA model in either grammar or diagram format, for the following TTF business process. Be sure to include all relevant entities, relationships, attributes, and cardinalities (minimum and maximum).
b. Convert your business process level model into a set of minimal relational database tables. Be sure to identify primary and foreign keys in the relational tables.
Tina's Toy Factory (TTF) is a very busy company where employees work very hard to make enough toys to satisfy consumer demand. Tina, the CEO, has asked you to design a conceptual model from which a database may be implemented using the REA ontology.
In order to build many different toys, TTF's employees determine the different raw material types that are required. For example, paper is needed for sports cards and plastic is needed for Barbie Dolls and Wrestle Mania toys. When an employee determines a need for new raw materials he or she initiates a requisition. A requisition cannot occur without an employee. During "busy season" (typically mid-August through mid-November because of additional volume needed for Christmas) TTF processes thousands of requisitions. Each requisition involves at least one type of raw material, but only one vendor. When an employee fills out a requisition, one intended vendor must be listed. At any time only one employee can be responsible for a requisition. An order can only be placed after the requisition has been approved by Tina and entered into the database (note: Tina is not considered to be an employee). Each requisition relates to only one order, however an order can encompass many requisitions. Orders for raw materials (obviously an order can be made for different raw material types) are made by an employee and for control purposes, Tina never approves the order (since she approves the requisition). All orders must specify the vendor. Multiple deliveries can relate to any order. When a delivery of raw materials occurs, a receiving report is filled out. A receiving report has to relate to at least one order.
With all of the manufacturing activity taking place at TTF, there is great demand for fixed assets. Tina is the only one allowed to order fixed assets (therefore she does not need to fill out a requisition - however, she does fill out an order). An order cannot involve both raw materials and fixed assets. Tina can order many different fixed assets at a time, and each individual fixed asset will be identified with a unique fixed asset number. Fixed assets are only entered into the database after they have been ordered. Usually it takes about two weeks after the order date for the fixed assets to be delivered. When the fixed assets are delivered they are recorded on a receiving report. However, a particular receiving report can only relate to raw materials or fixed assets, but not both. Exactly one employee and one vendor relate to each receiving report.
Most vendors allow for payments on account and for installment payments. Sometimes a payment will be made for all raw materials or fixed assets received in the prior month from the same vendor. TTF wants to allow for payments for other expenses such as payroll. A payment cannot be made to more than one vendor at a time. Tina makes all of the payments, and each payment is drafted on one cash account.
Tina, employees, vendors, cash accounts, and raw material types are entered into the database before any events involving them occur. However, instances of the mentioned agents and resources can relate to many events.
Be sure to incorporate each and every attribute from the following list once and only once in your solution. Do not add any attributes to your solution. You may use the abbreviations indicated in the parentheses.
Employee ID # (Emp-ID)
Tina's ID # (Tina-ID)
Receiving Report Date (RR-Date)
Cash Account Type (CA-Type)
Fixed Asset Description (FA-Desc)
Requisition Date (Req-Date)
Raw Material Type # (RM-Type #)
Vendor Name (V-Name)
Tina's Cell Phone # (T-Ph#)
Purchase Order # (PO#)
Raw Material Type Description (RM-Type-Desc)
Quantity of a Raw Material Type Requisitioned (Qty-Req)
Quantity of a Raw Material Type Ordered (Qty-Ord)
Purchase Order Date (PO-Date)
Vendor # (V-#)
Cash Account # (CA-#)
Cash Disbursement # (CD-#)
Dollar Amount of a Disbursement Applied to a Purchase (Amt-Applied)
Fixed Asset Acquisition Cost (FA-Cost)
Unit Cost of a Raw Material Type on an Order (Ord-Cost)
Quantity of a Raw Material Received in a Delivery (Qty-Recv)
Requisition # (Req-#)
Cash Disbursement Date (CD-Date)
Vendor Address (V-Addr)
Cash Disbursement Total Dollar Amount (CD-Amt)
Employee Name (E-Name)
Receiving Report # (RR#)
Fixed Asset # (FA#)
Estimated Cost of RM Type per Requisition (Est-Cost)
At the end of your solution, write any ambiguities you found in the narrative (if any) and assumptions you made to resolve those ambiguities for the Tina's Toy Factory problem.
Correct Answer:
Verified
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q45: What effect do cash disbursements in the
Q46: Examine the following value system level model
Q47: In a typical REA value chain for
Q48: GymForceful ordered new equipment on June 1.
Q49: List the resource, internal agent, external agent,
Q50: What document is often used to capture
Q51: Explain the two entities Inventory and Inventory
Q52: Given the following narrative description for Do-We,
Q54: Create a "generic" REA business process level
Q55: Given the following narrative description for Primarily
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents