Unformatted text preview: tory.ʹ Each ʹInventoryʹ must be linked to a ʹSaleʹ and can only be linked to at most one ʹSale.ʹ (8 points total - 4 points per question)
22) Each ʹReceive Goodsʹ must be linked to a ʹWarehouse Employeeʹ and can be linked to at most one
Answer: Each ʹWarehouse Employeeʹ may or may not be linked to a ʹReceive Goodsʹ and can be linked to
many ʹReceive Goods.ʹ
23) Each ʹReceive Goodsʹ must be linked to an ʹOrder Goodsʹ and can be linked to many ʹOrder Goods.ʹ
Answer: Each ʹOrder Goodsʹ may or may not be linked to a ʹReceive Goodsʹ and can be linked to at most
one ʹCash Payment.ʹ REA. Answer the following questions for the two REA segments of Cyclone Flutes Inc. shown in qeustion 22 and 23.
24) Create potential primary key(s) for the ʹOrder Goodsʹ entity. (2 points)
Answer: OrderNumber or OrderID
25) What type of entities are ʹReceive Goodsʹ and ʹOrder Goodsʹ (i.e. agent, event or resource)? (2 points)
View Full Document
This document was uploaded on 03/13/2014.
- Spring '14