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. 1. 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. Generate an output image
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
