1/28
Vocabulary flashcards defining key entity relationship modeling terms, attributes, relationship characteristics, and structural components.
Entity Relationship Model (ERM)
A model that forms the basis of an Entity Relationship Diagram (ERD) and represents the conceptual database as viewed by the end user using entities, attributes, and relationships.
Entity
An object of interest to the end user that corresponds to a table (not a row) in the relational environment, represented in ERDs by a rectangle containing the entity's noun name in all capital letters.
Entity Occurrence
A specific row or instance within a table in the relational environment, also referred to as an entity instance.
Required Attribute
An attribute that must have a value and cannot be left empty.
Optional Attribute
An attribute that does not require a value and can be left empty.
Domain
The set of possible values for a given attribute.
Identifier
One or more attributes that uniquely identify each entity instance.
Composite Identifier
A primary key composed of more than one attribute.
Composite Attribute
An attribute that can be subdivided to yield additional attributes.
Simple Attribute
An attribute that cannot be subdivided.
Single-Valued Attribute
An attribute that has only a single value.
Multivalued Attribute
An attribute that can have many values associated with a single entity instance.
Derived Attribute
An attribute whose value is calculated from other attributes.
Participants
The entities that participate in a relationship.
Connectivity
The classification of a relationship between entities, which includes 1:1, 1:M, and M:N.
Cardinality
An expression of the minimum and maximum number of entity occurrences associated with one occurrence of the related entity, indicated in ERDs using the format (x,y).
Existence Dependence
A condition where an entity can exist in the database only when it is associated with another related entity occurrence, characterized by having a mandatory foreign key.
Existence Independence
A condition where an entity can exist apart from all of its related entities; also referred to as a strong entity or regular entity.
Weak Relationship
A relationship that exists if the primary key of the related entity does not contain a primary key component of the parent entity; also called a non-identifying relationship.
Strong Relationship
A relationship that exists when the primary key of the related entity contains a primary key component of the parent entity; also called an identifying relationship.
Weak Entity
An entity that is existence-dependent on its parent entity and has a primary key that is partially or totally derived from the parent entity in the relationship.
Optional Participation
A condition in a relationship where one entity occurrence does not require a corresponding entity occurrence.
Mandatory Participation
A condition in a relationship where one entity occurrence requires a corresponding entity occurrence.
Relationship Degree
An indicator of the number of entities or participants associated with a relationship.
Unary Relationship
A relationship degree that exists when an association is maintained within a single entity.
Binary Relationship
A relationship degree that exists when two entities are associated.
Ternary Relationship
A relationship degree that exists when three entities are associated.
Recursive Relationship
A relationship that exists between occurrences of the same entity set within a single entity type.
Associative Entity
An entity used in the ER model to represent an M:N relationship between two or more entities, composed of the primary key attributes of each parent entity; also called a composite entity or bridge entity.