Dependent and Independent Entities

The Key-Based Data Model Relationships and Foreign Key Attributes Dependent and Independent Entities As you develop your data model, you may discover certain entities that depend upon the value of the foreign key attribute for uniqueness. For these entities, the foreign key must be a part of the primary key of the child

Dependent and Independent Entities

Previous Topic: Relationships and Foreign Key AttributesNext Topic: Identifying Relationships

Dependent and Independent Entities

As you develop your data model, you may discover certain entities that depend upon the value of the foreign key attribute for uniqueness. For these entities, the foreign key must be a part of the primary key of the child entity (above the line) to define each entity uniquely.

In relational terms, a child entity that depends on the foreign key attribute for uniqueness is named a dependent entity. In IDEF1X notation, dependent entities are represented as round-cornered boxes.

Entities that do not depend on any other entity in the model for identification are named independent entities. In IE and IDEF1X, independent entities are represented as square-cornered boxes.

Example of an independent entity and a dependent entity

Dependent entities are further classified as existence dependent, which means the dependent entity cannot exist unless its parent does, and identification dependent, which means that the dependent entity cannot be identified without using the key of the parent. Because PLAYERs can exist if they are not on a TEAM, the PLAYER entity is identification-dependent, but not existence-dependent.

In contrast, there are situations where an entity is existence-dependent on another entity. Consider two entities: ORDER, which a business uses to track customer orders, and LINE ITEM, which tracks individual items in an ORDER. The relationship between these two entities can be expressed as An ORDER <contains> one or more LINE ITEMS. In this case, LINE ITEM is existence-dependent on ORDER, because it makes no sense in the business context to track LINE ITEMS unless there is a related ORDER.

ncG1vNJzZmirY2Ourq3ZqKWar6NjsLC5jp6psKGeYsK0e7Kup6mnoql8eoGOfHhkfYKstq93o5qrmmN9pLGmuMSrYqtxW2p6hpq0aHmop5uotaa4xZh9oqSVqHyJoKyFZn6Kp567Zn6PiK2eqqaesrh7kW5rbnBhY7W1ucs%3D

 Share!