Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/25

Click to flip

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