Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Santa's Toy Factory ( STF ) is a busy company where employees work very hard to manufacture enough toys to satisfy consumer demand. STF has

Santa's Toy Factory (STF) is a busy company where employees work very hard to manufacture enough toys to satisfy consumer demand. STF has only one manufacturing facility and does not maintain separate warehouses. Santa, 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, STF's purchasing elves determine the different raw material types that are required. For example, cardboard and wood is needed for board games and plastic is needed for dolls and other toys. There is no formal materials requisition process. The purchase order process involves a buyer elf placing a purchase order with a vendor. During the summer months, purchase orders tend to be for a large number of raw materials types and for large quantities because STF is gearing up for the holiday season. If a vendor cannot ship the entire order immediately, it will provide STF with multiple projected deliveries. Each projected delivery is identified by lot number and can be for many types of raw materials. Each projected delivery also corresponds to a single delivery payment voucher. STF does not track the agents involved with the scheduled delivery or delivery payment vouchers.
A scheduled delivery can be fulfilled by either an actual receipt of the designated type of raw material or by an actual receipt of an approved substitute type of raw material. Most raw materials types have many substitutes and most raw materials types are substitutes for other raw materials types. Projected delivery quantities are always the same as delivery quantities received because STF does not allow projected shipments to be partially filled. Vendors sometimes combine projected shipments into one delivery. Each delivery is processed by one buyer elf. There are no purchase returns.
Scheduled payments always identify a specific account and require payment in full within two weeks of delivery. Sometimes actual dollar amounts of payments on delivered goods are slightly different from the scheduled payments due to raw materials substitutions. All cash disbursements are made by check. Check numbers across accounts are not unique.
Cashiers may pay several vouchers to a vendor with one check. There are no on-the-fly raw materials purchases. STF also purchases fixed assets and those activities are modelled in a different business process.
STF has cash disbursements related to other business processes. Employees, vendors, cash accounts, and raw material types are entered into the database before any events involving them occur.
Be sure to incorporate every attribute from the following list in your solution. Do not add any attributes to your solution. Please use the abbreviations indicated in the parentheses.
Buyer Elf number (Buyer #)
Raw Material quantity on hand (RM QOH)
Vendor number (Vendor #)
Check dollar amount (Chk Amt)
Projected delivery quantity (Proj Qty)
Cashier Elf name (Cashier name)
Purchase order number (PO #)
Vendor name (Vendor name)
Raw material number (RM #)
Projected dollar amount of payment (Proj $ amt)
Purchase order date (PO date)
Approved unit price of this raw material (App Price)
Delivery lot number (Lot #)
Dollar amount of this delivery (Delivery $ Amt)
Purchase order dollar amount (PO $ amt)
Cash account number (Acct #)
Delivery time stamp (Delivery time)
Cashier Elf number (Cashier #)
Check number (Check #)
Scheduled delivery date (Sch delivery date)
Buyer Elf name (Buyer name)
Individual accounts payable balance (A/P bal)
Bonding status (Bond status)
Delivery payment voucher number (Voucher #)
Projected date of payment (Proj pmt date)
Create an REA model for this business process. Label all classes, primary keys, and relationships and add all multiplicities.
Do not create relational tables for this model.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Glencoe Accounting Concepts Procedures Applicatons

Authors: McGraw-Hill Education

3rd Edition

0028036174, 978-0028036175

More Books

Students also viewed these Accounting questions

Question

Describe effectiveness of reading at night?

Answered: 1 week ago

Question

find all matrices A (a) A = 13 (b) A + A = 213

Answered: 1 week ago