WGU C170 Terms QUESTIONS AND
ANSWERS
Associative Entity - ✔✔All relationships for the (...) entity should be many.
Attribute - ✔✔An (...) is a property or characteristic of an entity.
Binary relationship - ✔✔A (...) is a relationship between two entity types.
Cardinality - ✔✔(...) represents the maximum number of entities that can be involved in a particular
relationship.
Cascade Delete - ✔✔Will delete all records that reference the primary key
Database - ✔✔A (...) is a collection of information that is organized so that it can easily be accessed,
managed, and updated.
E-R model - ✔✔An (...) is a data model for describing a database in an abstract way.
Entity - ✔✔An (...) is an object or event in our environment that we want to keep track of.
Intersection Data - ✔✔Associated with the concatenation of two segments
Modality - ✔✔(...) represents the minimum number of entity occurrences that can be involved in a
relationship.
Ternary Relationship - ✔✔A (...) relationship is when three entities participate in the relationship.
Unary Relationships - ✔✔(...) relationships associate occurrences of an entity type with other
occurrences of the same entity type.
, Unique Identifier - ✔✔A (...) is any identifier which is guaranteed to be unique among all identifiers
used for those objects and for a specific purpose.
Data encryption - ✔✔When data is (...), it is changed, bit by bit or character by character, into a form
that looks totally garbled. It can and must be reconverted, or decrypted, back to its original form to
be of use.
Data normalization - ✔✔Is a methodology for organizing attributes into tables so that redundancy
among the non-key attributes is eliminated.
Data volatility - ✔✔Describes how often stored data is updated.
Data Volume Assessment - ✔✔Understanding of how much data will be in a database or a table
within a database
Denormalization - ✔✔The act of duplicating data in a database for performance or the preservation
of historical information
Disaster recovery - ✔✔Involves rebuilding an entire information system or significant parts of one
after a catastrophic natural disaster such as a hurricane, tornado, earthquake, building collapse, or
even a major fire
Index - ✔✔Used to help a DBMS find data quickly
Logical view - ✔✔Is a mapping onto a physical table or tables that allows an end user to access only a
specified portion of data.
Response time - ✔✔Is the delay from the time that the Enter Key is pressed to execute a query until
the result appears on screen.
Throughput - ✔✔Is the measure of how many queries from simultaneous users must be satisfied in a
given period of time by the application set and the database that it supports.
ANSWERS
Associative Entity - ✔✔All relationships for the (...) entity should be many.
Attribute - ✔✔An (...) is a property or characteristic of an entity.
Binary relationship - ✔✔A (...) is a relationship between two entity types.
Cardinality - ✔✔(...) represents the maximum number of entities that can be involved in a particular
relationship.
Cascade Delete - ✔✔Will delete all records that reference the primary key
Database - ✔✔A (...) is a collection of information that is organized so that it can easily be accessed,
managed, and updated.
E-R model - ✔✔An (...) is a data model for describing a database in an abstract way.
Entity - ✔✔An (...) is an object or event in our environment that we want to keep track of.
Intersection Data - ✔✔Associated with the concatenation of two segments
Modality - ✔✔(...) represents the minimum number of entity occurrences that can be involved in a
relationship.
Ternary Relationship - ✔✔A (...) relationship is when three entities participate in the relationship.
Unary Relationships - ✔✔(...) relationships associate occurrences of an entity type with other
occurrences of the same entity type.
, Unique Identifier - ✔✔A (...) is any identifier which is guaranteed to be unique among all identifiers
used for those objects and for a specific purpose.
Data encryption - ✔✔When data is (...), it is changed, bit by bit or character by character, into a form
that looks totally garbled. It can and must be reconverted, or decrypted, back to its original form to
be of use.
Data normalization - ✔✔Is a methodology for organizing attributes into tables so that redundancy
among the non-key attributes is eliminated.
Data volatility - ✔✔Describes how often stored data is updated.
Data Volume Assessment - ✔✔Understanding of how much data will be in a database or a table
within a database
Denormalization - ✔✔The act of duplicating data in a database for performance or the preservation
of historical information
Disaster recovery - ✔✔Involves rebuilding an entire information system or significant parts of one
after a catastrophic natural disaster such as a hurricane, tornado, earthquake, building collapse, or
even a major fire
Index - ✔✔Used to help a DBMS find data quickly
Logical view - ✔✔Is a mapping onto a physical table or tables that allows an end user to access only a
specified portion of data.
Response time - ✔✔Is the delay from the time that the Enter Key is pressed to execute a query until
the result appears on screen.
Throughput - ✔✔Is the measure of how many queries from simultaneous users must be satisfied in a
given period of time by the application set and the database that it supports.
