Question: Draw a conceptual data model to model the scenario. Use the model constructs on the E-R model and the enhanced E-R model as appropriate and

Draw a conceptual data model to model the scenario. Use the model constructs on the E-R model and the enhanced E-R model as appropriate and follow the modeling conventions. include all appropriate completeness constraints, disjointness constraints, and subtype indicators in your conceptual data models.

Evergreen Production Company (EPC) produces a variety of parts that are sold to customers in a variety of industries. Attributes of Part include EPCPartID, EPCPartName, EPCColor, and EPCWeight. Attributes of Customer include EPCCustomerID, EPCCustomerName, and EPCCustomerAddress (composed of EPCStreet, EPCCity, EPCState, and EPCZipCode). Customers place orders with Evergreen Production Company. Attributes of Order are EPCOrderID and EPCOrderDate. All customers have placed at least one order and customers may place many orders over time. Each order is placed by a single customer. Orders can include one or more part. A part can be requested by one or more order. Evergreen Production Company keeps track of the quantity of each part included in an order.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!