INTRODUCTION Again, Nathan A. of Luke Importing Company Incorporated has decided to expand his business and needs to staff and support a procurement system to acquire the items sold at Luke Importing. You have previously created a data model for Luke Importing. Extend the work to represent a database design.

TASK #1 Convert the data model to a database design. That is, specify tables, primary keys, and foreign keys. Describe how you have represented weak entities, if any exist. Describe how you have represented supertype and subtype entities, if any exist. Document the maximum and minimum cardinality enforcement using referential integrity actions for required parents, if any, and for required children, if any.

TASK #2 Create a visual representation of your database design as a Crows Foot E-R diagram. Design should represent Figure 3-11.

Employee Store FirstName StorelD Name ItemID Name LastName 0 Purchase Purchased Item Receiving Clerk Purchasing Agent Tim InsuredValue ArrivalCondition Shipment Shipmenti SentDate Time ReceivedDate Time Shipper Name Employee Store FirstName StorelD Name ItemID Name LastName 0 Purchase Purchased Item Receiving Clerk Purchasing Agent Tim InsuredValue ArrivalCondition Shipment Shipmenti SentDate Time ReceivedDate Time Shipper Name