Solved

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

Question 127

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

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents