Previous Topic: Tables

Next Topic: Attributes and Columns


Types of Entities/Tables

Two types of entities/tables can be drawn in a data model:

Independent Entity

An entity whose instances can be uniquely identified without determining its relationship to another entity. It is represented as a box with square corners.

Dependent Entity

An entity whose instances cannot be uniquely identified without determining its relationship to another entity or entities. It is represented as a box with rounded corners.

When you add an entity, the entity type is determined based on the relationship in which it is involved. For example, when you initially place an entity in a model, it is represented as an independent entity. When you connect the entity to another entity using a relationship, it is determined if the entity is independent or dependent based on the relationship type.