Attributes-Entities   «Prev  Next»

Entities and their Attributes - Exercise

Objective:Convert business objects and their characteristics into entities and their attributes.

Exercise scoring

This exercise is worth a total of 20 points. You will receive up to five points for each correctly completed step outlined below.
Downloads: This exercise is based on the case study, available for download ERD Case Study.

Background/overview

In the preceding lesson, you learned that database designers convert business objects and their characteristics into entities and their attributes. This is the required format for creating an ER diagram. At this point in the design process, you are simply making lists of entities and attributes.

Instructions

Based on the case study you downloaded, perform the following operations:
  1. Convert the three business objects previously identified on the data entry form into entities.
  2. Convert the characteristics you identified for these objects into attributes.
  3. Find one additional business object mentioned in the case study and convert it into an entity.
  4. Posit two imaginary attributes for this new entity.

As mentioned in the lesson, it is customary to list entities in the singular. For this exercise, follow the customary practice. Some designers also like to write entities in ALL CAPS to distinguish them from attributes. Following the format in the example below, list attributes beneath entities:

  1. STUDENTS
  2. Last name
  3. First name
  4. Street address (etc.)

Hints


The business object not on the data entry form was mentioned as being stored on paper.

Submitting your exercise

Type or paste your answer into the text box below, then click Submit to submit your answer and view a results page.