Show TOC

Entity TypesLocate this document in the navigation structure

Use

An entity is a physical or abstract object (for example, Mr. Douglas, the "Sales Information System" project) that can be distinguished from other objects and for which information is to be stored. Entities are divided into entity types according to their properties.

Each entity type is assigned attributes, which describe the entities of the entity type. The properties of entities are described by means of actual values for the attributes.

An attribute consists of a name and a definition of the possible values for the attribute (for example, the attribute color with the values white, black, yellow, and so on). One or more attributes are labeled as key attributes. The values of the key attributes uniquely identify an entity within its entity type.

Example

Entities, entity types, attributes

Term

Example

Entities

Mr Douglas

Ms Roberts

Ms Stone

Project

'Sales Information System'

Project 'Warehouse Management'

Entity Types

Employee

Project

Attributes

  • Attributes of entity type 'employee':

    Personnel Number (key attribute)

    Name

    Address

    Entry date

  • Attributes of entity type 'project':

    Project Number (key attribute)

    Name

    Start

    End

    Project Manager
More Information