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

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


Play button


Play button




Click to flip

23 Cards in this Set

  • Front
  • Back
Simple Attribute: An attribute that ____ be broken into small ___
cannot, component
Composite Attribute: An attribute that ___ be broken down into smaller ____.
can, component
Single Valued Attribute: An attribute that can take on _____ value for a give entity _____
only one, instance
Multi-Valued Attribute: An attribute that __ take on __ value for a given entity ____
may, multiple, instance
Derived Attribute: An attribute whose value can be ____ from related attribute value.
computed calculated
Primary Key: An attribute (or combination of attribute) that ___ ___ .
unique, identified
Composite Primary Key: A primary key that consists of a ___ of attribute.
Foreign Key: An attribute in one table that matches the ___ of another table.
primary key
Candidate Key: An attribute of combination of attributes that ___ served as a primary key, but was not selected to e the primary key.
could have
Surrogate Key: A table identifier that is ___ by the data modeler.
make up
Entity Integrity: When all of rows of a database table are ____ .
unique id
Referential Integrity: When all the foreign key in one table either ___ the primary key value in the related table or are ___ .
match, null
A meaningful association between__ Type
Connectivity: Describe the mapping of associated ____ in a relationship. The possible values of connectivity are __ and ___
entity instance, one, many
1:1 :A record in one entity is related to a ____ of ___ records in another entity.
maximum, one
1:M : A record in one entity is related to a ___ of ___ records in another entity.
maximum, many
M:N :Individual record ___ side of relationship can be related to ___ records on the other side of the relationship.
each, many
Cardinality Constraint: Specifies both ___ and ___ number of instances of entity B that can be associated with each instance of entity A.
maximum, minimum
Degree: The ___ of entity type that participate in a realtionship
Unary: a relationship between the instances of a ___ entity type.
Binary: A relationship between the instances of ___ entity types
Ternary: A simultaneous relationship among the instances of ___ entity types.
Strength: Whether or not an entity type can exist independently of other entity types.
If an entity type can exit independently of their entity type it is called ___ enity type, if it cannot, it is call a ___ entity type
___ entiy type do not have identifiers of there own, they share the identifier of there ___
The relationship between a ___ entity type and its owner is call a(n) ____ relationship.
strong, weak, strong, owner, weak, identifying.