Examlex

Solved

The Entity-Relationship (E-R) Diagram Below Represents an Order Entry/sales Process

question 90

Essay

The entity-relationship (E-R) diagram below represents an order entry/sales process, but with the names of certain entities, characteristics of relationships, and relationship cardinalities removed from the diagram. The names omitted are:
EntitiesCUSTOMERSINVENTORYSHIPMENTSCharacteristics of the Relationshipsactivatebilled-togenerateSALES-RELATIONStrigger\begin{array}{c}\begin{array}{lll}\underline{\text {Entities}}\\\text {CUSTOMERS}\\\text {INVENTORY}\\\text {SHIPMENTS}\\\\\\\end{array}\begin{array}{lll} \underline{\text {Characteristics of the Relationships}}\\ \text {activate}\\\text {billed-to}\\\text {generate}\\\text {SALES-RELATIONS}\\\text {trigger}\\ \end{array}\end{array}

Required:
Complete TB Figure 10.8 by:
a. Inserting the names from the above lists into the rectangles (entities) or diamonds (characteristics of the relationships), respectively, where they belong
b. Inserting a 1 or an N where necessary next to the connecting lines to indicate the cardinality of the relationships


Definitions:

Related Questions