ER Diagrams   «Prev  Next»

Identify Entity Relationships - Exercise

Objective: Identify direct business associations in the Stories on CD conceptual model.

Business facts

A customer places an order. An order requests CD titles. A distributor supplies CD titles. Show these direct conceptual associations before introducing an order-line entity.

Customer, Order, Distributor and CD boxes; Distributor and CD are already connected.
Complete the missing associations. The sketch has no cardinality or participation symbols.

Four questions

  1. Which entity is directly related to CUSTOMER?
  2. Which entities are directly related to ORDER?
  3. Which entities are directly related to CD?
  4. Which entity is directly related to DISTRIBUTOR?

List the directly connected entity names for each question. An association reached through another entity is indirect in this sketch.

Self-assessment: 20 points

Award up to 5 points per question: 5 for the complete correct set, 3 for one correct entity when two are required with no incorrect additions, and 0 for an incorrect set. Total: 20 points. The page displays a model answer; it does not automatically grade free text.

Submit your response

Enter your answers, then select Submit to compare them with the model answer.

Namecheap 1