WGU C175 Data Management Foundation
Questions and Answers
1. Associative Entity: An associative entity is an element of the entity-relationship model. All
relationships for the associative entity should be many.
2. Attribute: An attribute is a property or characteristic of an entity.
3. Binary relationship: A binary relationship is a relationship between two entity types.
4. Candidate Key: Is any column or a combination of columns that can qualify as unique key in
database.
5. Cardinality: Cardinality represents the maximum number of entities that can be involved
in a particular relationship.
6. Cartesian product: Usually the result of a missing join condition or a method of expanding
the data of 1 table by the number of rows in the second table.
7. Cascade Delete: Will delete all records that reference the primary key
8. column subquery: Returns a single column of one or more values.
9. data encryption: When data is encrypted, it is changed, bit by bit or character by character,
1/
8
, into a form that looks totally garbled. It can and must be reconverted, or decrypted, back to its
original form to be of use.
10. Data normalization: Is a methodology for organizing attributes into tables so that
redundancy among the non-key attributes is eliminated.
11. Data volatility: Describes how often stored data is updated.
12. Data Volume Assessment: Understanding of how much data will be in a database or a
table within a database
13. Database: A database is a collection of information that is organized so that it can easily be
accessed, managed, and updated.
14. DCL: Data control language is used to control access to data stored in a database.
15. DDL: Data definition language - involves instructing the DBMS software on what tables will
be in the database, what attributes will be in the tables, which attributes will be indexed, and so forth.
16. Definer: Definer is a MySQL term where AuthID is the same for another DBMS
17. Denormalization: The act of duplicating data in a database for performance or the
preservation of historical information
18. disaster recovery: Involves rebuilding an entire information system or significant
2/
8
Questions and Answers
1. Associative Entity: An associative entity is an element of the entity-relationship model. All
relationships for the associative entity should be many.
2. Attribute: An attribute is a property or characteristic of an entity.
3. Binary relationship: A binary relationship is a relationship between two entity types.
4. Candidate Key: Is any column or a combination of columns that can qualify as unique key in
database.
5. Cardinality: Cardinality represents the maximum number of entities that can be involved
in a particular relationship.
6. Cartesian product: Usually the result of a missing join condition or a method of expanding
the data of 1 table by the number of rows in the second table.
7. Cascade Delete: Will delete all records that reference the primary key
8. column subquery: Returns a single column of one or more values.
9. data encryption: When data is encrypted, it is changed, bit by bit or character by character,
1/
8
, into a form that looks totally garbled. It can and must be reconverted, or decrypted, back to its
original form to be of use.
10. Data normalization: Is a methodology for organizing attributes into tables so that
redundancy among the non-key attributes is eliminated.
11. Data volatility: Describes how often stored data is updated.
12. Data Volume Assessment: Understanding of how much data will be in a database or a
table within a database
13. Database: A database is a collection of information that is organized so that it can easily be
accessed, managed, and updated.
14. DCL: Data control language is used to control access to data stored in a database.
15. DDL: Data definition language - involves instructing the DBMS software on what tables will
be in the database, what attributes will be in the tables, which attributes will be indexed, and so forth.
16. Definer: Definer is a MySQL term where AuthID is the same for another DBMS
17. Denormalization: The act of duplicating data in a database for performance or the
preservation of historical information
18. disaster recovery: Involves rebuilding an entire information system or significant
2/
8
