Module 4: Entity Relationship (ER) Modeling

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/28

flashcard set

Earn XP

Description and Tags

Vocabulary flashcards defining key entity relationship modeling terms, attributes, relationship characteristics, and structural components.

29 Terms

1
New cards

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.

2
New cards

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.

3
New cards

Entity Occurrence

A specific row or instance within a table in the relational environment, also referred to as an entity instance.

4
New cards

Required Attribute

An attribute that must have a value and cannot be left empty.

5
New cards

Optional Attribute

An attribute that does not require a value and can be left empty.

6
New cards

Domain

The set of possible values for a given attribute.

7
New cards

Identifier

One or more attributes that uniquely identify each entity instance.

8
New cards

Composite Identifier

A primary key composed of more than one attribute.

9
New cards

Composite Attribute

An attribute that can be subdivided to yield additional attributes.

10
New cards

Simple Attribute

An attribute that cannot be subdivided.

11
New cards

Single-Valued Attribute

An attribute that has only a single value.

12
New cards

Multivalued Attribute

An attribute that can have many values associated with a single entity instance.

13
New cards

Derived Attribute

An attribute whose value is calculated from other attributes.

14
New cards

Participants

The entities that participate in a relationship.

15
New cards

Connectivity

The classification of a relationship between entities, which includes 1:1, 1:M, and M:N.

16
New cards

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)(x,y).

17
New cards

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.

18
New cards

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.

19
New cards

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.

20
New cards

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.

21
New cards

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.

22
New cards

Optional Participation

A condition in a relationship where one entity occurrence does not require a corresponding entity occurrence.

23
New cards

Mandatory Participation

A condition in a relationship where one entity occurrence requires a corresponding entity occurrence.

24
New cards

Relationship Degree

An indicator of the number of entities or participants associated with a relationship.

25
New cards

Unary Relationship

A relationship degree that exists when an association is maintained within a single entity.

26
New cards

Binary Relationship

A relationship degree that exists when two entities are associated.

27
New cards

Ternary Relationship

A relationship degree that exists when three entities are associated.

28
New cards

Recursive Relationship

A relationship that exists between occurrences of the same entity set within a single entity type.

29
New cards

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.