Midterm Spring 2013 - Form B

Foreachoftheseindicatethe

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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 ʹWarehouse Employee.ʹ 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) Answer: Ev...
View Full Document

Ask a homework question - tutors are online