Use figure 2-22 to answer

c. What is the purpose of the PRODUCED IN entity?

d. The PRODUCED IN entity has two binary relationships one with the WORK CENTER entity and one with the PRODUCT entity. Look at the cardinalities of those two relationships and explain in words the meaning (business relationship) of those two binary relationships. A work center is not a physical location (i.e. Reno, Las Vegas), for this application; a work center for a wood furniture manufacturing company represents a place where a specific type of work happens like painting or sanding.

e. All entities should have a primary key, even though this diagram shows many entities without primary keys. What would be an appropriate primary key for the PRODUCED IN entity? Explain why you chose that primary key for the PRODUCED IN entity.

f. The textbook author frequently leaves an intersection entity with no attributes on "first draft" data models provided in the book. Thus, the PRODUCED IN entity has no attributes on the data model. Think about the purpose of this entity for the Pine Valley Furniture Company and name at least one non-key attribute that you believe might be stored in the PRODUCED IN entity. I recommend that you think about what data might have to be stored for a furniture manufacturing company in order to answer this question

DOES BUSINESS IN Serves SALESPERSON PK Salesperson ID Salesperson Name Salesperson Telephone Salesperson Fax TERRITORY PK Territory ID Territory Name HE PRODUCT LINE PK Product Line ID Product Line Name CUSTOMER PK Customer ID Customer Name Customer Address Customer Postal Code Submits Includes ORDER PK Order ID Order Date ORDER LINE PRODUCT PK Product ID Product Description Product Finish Product Standard Price Ordered Quantity USES PRODUCED IN VENDOR PK Vendor ID Vendor Name Vendor Address Goes Into Quantity WORK CENTER PK Work Center ID Work Center Location RAW MATERIAL SUPPLIES PK Material ID Material Name Material Standard Cost Supply Unit Price Unit Of Measure Is Supervised By EMPLOYEE Supervises - HPK Employee ID SKILL HAS SKILL Employee Name PK Skill Hec Employee Address WORKS IN