Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
25 Cards in this Set
- Front
- Back
|
binary
|
association between two entities
|
|
|
cardinality
|
property that assigns a specific value to connectivity and expresses the range of allowed entity occurrences associated with a single occurrence of the related entity
|
|
|
composite attribute
|
attribute that can be further subdivided to yield additional attributes
|
|
|
composite identifier
|
key composed of more than one attribute
|
|
|
derived attribute
|
attribute that does not physically exist within the entity and is derived via an algorithm
|
|
|
existence-dependent
|
property of an entity that can exist apart from one or more related entities
|
|
|
identifiers
|
one or more attributes that uniquely identify each entity existence
|
|
|
iterative process
|
process based on repetition of steps and procedures
|
|
|
mandatory participation
|
relationship in which one entity occurrence must have a corresponding occurrence in another entity
|
|
|
multivalued attributes
|
attribute that can have many values for a single entity occurrence
|
|
|
non-identifying relationship
|
relationship in which the primary key of the related entity does not contain a primary key of the parent entity
|
|
|
optional attribute
|
attribute that does not require a value; can be left empty
|
|
|
participants
|
entities that participate in a relationship
|
|
|
recursive relationship
|
relationship found within a single entity type
|
|
|
relational schema
|
organization of relational database as described by the database administrator
|
|
|
relationship degree
|
number of entities or participants associated with a relationship
|
|
|
required attribute
|
attribute that must have a value
|
|
|
simple attribute
|
attribute that cannot be subdivided into meaningful components
|
|
|
single-valued attribute
|
attribute that can have only one value
|
|
|
strong (identifying) relationship
|
relationship that occurs when two entities are existence-dependent; exists when the primary key of the related entity contains the primary key of the parent entity
|
|
|
strong (regular) entity
|
entity that is existence-dependent; can exist apart from all of its related entities
|
|
|
ternary relationship
|
association between three entities
|
|
|
unary relationship
|
association between within one entity
|
|
|
weak entity
|
entity that displays existence dependence and inherits the primary key of its parent entity
|
|
|
weak relationship
|
relationship in which the primary key of the related entity does not contain a primary key component of the parent entity
|
