19.5 Develop a data model of Fred's Train Shop's expenditure cycle activities related to the acquisition of office equipment and other fixed assets. Fred sometimes orders multiple pieces of equipment. Vendors usually ship the entire order but sometimes are out of stock of some items. In such cases, they immediately ship to Fred what they have in stock and then send a second shipment when they obtain the other items. Conversely, several orders placed within a short time period with the same vendor might be filled with one delivery. Assume that Fred makes installment payments for most fixed-asset acquisitions but occasionally pays for some equipment in full at the time of purchase. Required Draw an REA diagram of your data model. Be sure to include cardinalities.
Added by John A.
Close
Step 1
- **Vendor**: The supplier of the equipment. - **Equipment**: The fixed assets being acquired. - **Shipment**: The delivery of equipment from the vendor. - **Payment**: The financial transaction for the equipment. Show more…
Show all steps
Your feedback will help us improve your experience
Yujie Wang and 78 other Principles of Accounting educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Recommended Videos
ENTITY RELATIONSHIP DIAGRAM Shown here is a partial entity relationship diagram of a purchase system. Describe the business rules represented by the cardinalities in the diagram. PROBLEM 4: ENTITY RELATIONSHIP DIAGRAM Updates Contains Inventory Supplier Receiving Report Is Associated with Purchase Order
Akash M.
1.The relationship between the Sale and Receive Cash events for installment sales 2.The relationship between the Sale and Receive Cash events at a convenience store. 3.The Take Customer Order-Sale relationship in a situation when occasionally several shipments are required to fll an order because some items were out of stock.(presumes that one sale/order fulfillment event can be linked to multiple orders.with occasional partial deliveries because items need to be back ordered 4.The relationship between the Receive Inventory and Disburse Cash events in the case where suppliers require payment in advance,in full. 5.The relationship between the Sale and Receive Cash events for Dell computers.which requires customers to pay the entire amount of their purchase in advance,prior to Dell shipping the merchandise
Automata Inc. produces specialty vehicles by contract. The company operates several departments, each of which builds a particular vehicle, such as a limousine, a truck, a van, or an RV. Before a new vehicle is built, the department places an order with the purchasing department to request specific components. Automata's purchasing department is interested in creating a database to keep track of orders and to accelerate the process of delivering materials. The order received by the purchasing department may contain several different items. An inventory is maintained so that the most frequently requested items are delivered almost immediately. When an order comes in, it is checked to determine whether the requested item is in inventory. If an item is not in inventory, it must be ordered from a supplier. Each item may have several suppliers. Given the functional description of the processes encountered at Automata's purchasing department, do the following: a. Identify all of the main entities b. Draw a Crow's Foot ERD for Automata Inc. and list all the assumptions you make based on your understanding of the problem
Recommended Textbooks
Horngren’s Cost Accounting
Cost Accounting A Managerial Emphasis
Principles of Accounting Volume 1: Financial Accounting
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD