Entities and Their Attributes - Exercise

Objective: Convert business objects and their characteristics into four entity types with two attributes each.

Use the Stories on CD case study. The relevant facts are summarized below so you can complete the exercise without the download.

Case-study facts

The order-entry form records customers (customer number and last name), CDs (CD number and title), and orders (order date and whether the order has shipped). The business also keeps distributor details on paper. A form is an interface used to record an order, rather than the order itself.

Four tasks

Name the three entity types represented by the order-entry form.
List two appropriate attributes under each of those three entity types.
Identify the additional entity type suggested by the paper records.
Propose two appropriate attributes for that additional entity type; label them as proposed rather than confirmed requirements.

Use singular entity names. Capital letters are a presentation convention for this exercise. For example:

STUDENT
  Student ID
  Last name

Submit four entity names with two attributes under each. You are preparing a conceptual model; executable SQL and a complete table design are not required.

Self-assessment: 20 points

Task 1: 5 points (2 for Customer, 2 for CD/Product, 1 for Order). Task 2: 5 points for correctly assigned attributes (1 per attribute, capped at 5; provide all six). Task 3: 5 points for Distributor or an equivalent supplier concept. Task 4: 5 points (2 per suitable proposed attribute and 1 for identifying them as assumptions to validate). This is a self-assessment; the page displays a model answer and does not grade free text.

Submit your response

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

Your answers