WGU C170 Terms Complete Solutions
Associative Entity Ans- All relationships for the (...) entity should be many.
Attribute Ans- An (...) is a property or characteristic of an entity.
Binary relationship Ans- A (...) is a relationship between two entity types.
Cardinality Ans- (...) represents the maximum number of entities that can be involved in a particular
relationship.
Cascade Delete Ans- Will delete all records that reference the primary key
Database Ans- A (...) is a collection of information that is organized so that it can easily be accessed,
managed, and updated.
E-R model Ans- An (...) is a data model for describing a database in an abstract way.
Entity Ans- An (...) is an object or event in our environment that we want to keep track of.
Intersection Data Ans- Associated with the concatenation of two segments
Modality Ans- (...) represents the minimum number of entity occurrences that can be involved in a
relationship.
Ternary Relationship Ans- A (...) relationship is when three entities participate in the relationship.
Unary Relationships Ans- (...) relationships associate occurrences of an entity type with other
occurrences of the same entity type.
, Unique Identifier Ans- A (...) is any identifier which is guaranteed to be unique among all identifiers used
for those objects and for a specific purpose.
Data encryption Ans- 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 Ans- Is a methodology for organizing attributes into tables so that redundancy
among the non-key attributes is eliminated.
Data volatility Ans- Describes how often stored data is updated.
Data Volume Assessment Ans- Understanding of how much data will be in a database or a table within a
database
Denormalization Ans- The act of duplicating data in a database for performance or the preservation of
historical information
Disaster recovery Ans- 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 Ans- Used to help a DBMS find data quickly
Logical view Ans- Is a mapping onto a physical table or tables that allows an end user to access only a
specified portion of data.
Response time Ans- Is the delay from the time that the Enter Key is pressed to execute a query until the
result appears on screen.
Throughput Ans- 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.
Associative Entity Ans- All relationships for the (...) entity should be many.
Attribute Ans- An (...) is a property or characteristic of an entity.
Binary relationship Ans- A (...) is a relationship between two entity types.
Cardinality Ans- (...) represents the maximum number of entities that can be involved in a particular
relationship.
Cascade Delete Ans- Will delete all records that reference the primary key
Database Ans- A (...) is a collection of information that is organized so that it can easily be accessed,
managed, and updated.
E-R model Ans- An (...) is a data model for describing a database in an abstract way.
Entity Ans- An (...) is an object or event in our environment that we want to keep track of.
Intersection Data Ans- Associated with the concatenation of two segments
Modality Ans- (...) represents the minimum number of entity occurrences that can be involved in a
relationship.
Ternary Relationship Ans- A (...) relationship is when three entities participate in the relationship.
Unary Relationships Ans- (...) relationships associate occurrences of an entity type with other
occurrences of the same entity type.
, Unique Identifier Ans- A (...) is any identifier which is guaranteed to be unique among all identifiers used
for those objects and for a specific purpose.
Data encryption Ans- 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 Ans- Is a methodology for organizing attributes into tables so that redundancy
among the non-key attributes is eliminated.
Data volatility Ans- Describes how often stored data is updated.
Data Volume Assessment Ans- Understanding of how much data will be in a database or a table within a
database
Denormalization Ans- The act of duplicating data in a database for performance or the preservation of
historical information
Disaster recovery Ans- 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 Ans- Used to help a DBMS find data quickly
Logical view Ans- Is a mapping onto a physical table or tables that allows an end user to access only a
specified portion of data.
Response time Ans- Is the delay from the time that the Enter Key is pressed to execute a query until the
result appears on screen.
Throughput Ans- 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.
