Previous Topic: General Guidelines for Identifying RelationshipsNext Topic: Establishing Naming Conventions for the Attributes


Identifying Attributes

This section contains the following topics:

Overview

Establishing Naming Conventions for the Attributes

Identifying the Attributes of Each Entity

Identifying the Attributes for Each Relationship Type

Identifying Attribute Characteristics

Overview

Attributes and values

An attribute is the smallest unit of data that describes an entity or a relationship. A single occurrence of an attribute is called a value. For example, John Smith might be one of several values that exist for the attribute NAME of the entity EMPLOYEE. Several synonyms are used in the computer industry to refer to an attribute, including data item, data element, field, and column. All of these terms have roughly the same meaning.

In this chapter, we will identify the attributes that are associated with each entity and data relationship defined so far during the logical design process.

Identifying data attributes involves the following procedures:

  1. Establishing naming conventions for the attributes
  2. Identifying the attributes of each entity
  3. Identifying the attributes for each relationship type

Each of these procedures is explained below.