Developing a Conceptual Model › Identifying Relations

Identifying Relations

When you finish identifying the entities and attributes of your conceptual data model, you are ready to identify the relations. The purpose of this task is to produce an Entity-Relationship diagram (ERD) of your data model, showing the types of relationships that link the entities. The diagram eventually will be translated into a data model in CA 2E.

The following examples show how you can identify and represent relations in a data model. You can use any diagramming methodology.

This task consists of these steps:

• Step 1 explains how to identify relationships between entities or between an entity and an attribute.
• Step 2 describes how to select a primary key for an entity.