Database Design   «Prev  Next»

Identify Business Objects and Attributes - Exercise

Objective: Identify three business objects and two attributes of each from an order-entry form.

The Stories on CD case study supplies additional background. The facts needed for this exercise are summarized below.

Order-entry scenario

Stories on CD records customer number, first and last name, address and phone; CD number, CD title and price; and order date and whether the order has shipped. A customer can place orders containing CDs.

  1. Name three business objects represented by these facts.
  2. List two attributes for each object. Distinguish an order from the form used to enter it.

Self-assessment: 10 points

Award up to 5 points for the three appropriate object types (2 for Customer, 2 for CD/Product, 1 for Order) and up to 5 for attributes: 1 point per correctly assigned attribute, capped at 5. Supply all six attributes even though this part is capped at 5 points. 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.