Entities (Tables) and their Attributes - Exercise

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.

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.)

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