Previous Topic: Generalization and Differentiation of Entities

Next Topic: Domains

Step 2: Identifying Entity Attributes

Attributes supply informational detail to the entity. An entity can have one or several attributes. Each instance of an entity must contain values for all the attributes to define it. For possible values an attribute can take, see the topic, Domains, at the end of this step.

Each attribute represents one characteristic of the entity.

Beginning with the Customer entity, you would consider the following its potential "attributes":

CUSTOMER

Customer Code

Customer Name

Customer Address

Customer Credit Limit

Customer Account Balance

For the Product entity, the attributes would be:

PRODUCT

Product code

Product Name

Product Type

Product Description

After identifying all the attributes for the primary entities of your Order Entry application, you have a list that looks like this:

Entity

Attributes

Customer

Customer Code

Customer Name

Customer Address

Customer Credit Limit

Customer Account Balance

Product

Product Code

Product Name

Product Type

Product Description

Order

Order Code

Order Quantity

Order Line

Vendor ID

Customer Code

Product Code

Vendor

Vendor ID

Vendor Name

Vendor Address

Foreign Vendor

Foreign Vendor ID

Foreign Vendor Name

Foreign Vendor Address

Foreign Vendor Country

Foreign Vendor Duty Percentage

Purchase Order

Purchase Order Code

Purchase Order Quantity

Purchase Order Line