Previous Topic: Identify Attributes and Unique Identifiers for the EntitiesNext Topic: Select Each Entity’s Unique Identifier

Data Modeling › Data Model › Identify the Attributes for Each Entity

Identify the Attributes for Each Entity

An attribute is any detail that serves to qualify, identify, classify, quantify, or express the state of an entity. An attribute can also be any description of a thing of significance. The attributes must describe the entity against which they are shown.

Reviewing the data elements you identified during requirements analysis, and taking into consideration the entities you have already identified, it is possible to identify the attributes. List the attributes beside the appropriate entity as in the following table:

Entity

Attribute

COURSE

Course code
Course name

HORSE

Horse code
Horse name
Horse gender
Date of birth

JOCKEY

Jockey code
Jockey name
Jockey gender

SIRE

Sire code
Sire name
Sire Date of birth

DAM

Dam code
Dam name
Dam Date of birth

RACE

Course code
Course name
Race date
Race time
Race name
Going conditions
Distance
Prize money
Horse code
Horse name
Horse gender
Date of birth
Jockey code
Jockey name
Finishing position
Handicap
Entry status