Data Management Foundation C175 WGU
Associative Entity - ANS-An associative entity is an element of the entity-relationship
model. All relationships for the associative entity should be many.
Attribute - ANS-An attribute is a property or characteristic of an entity.
Binary relationship - ANS-A binary relationship is a relationship between two entity
types.
Candidate Key - ANS-Is any column or a combination of columns that can qualify as
unique key in database.
Cardinality - ANS-Cardinality represents the maximum number of entities that can be
involved in a particular relationship.
Cartesian product - ANS-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.
Cascade Delete - ANS-Will delete all records that reference the primary key
column subquery - ANS-Returns a single column of one or more values.
data encryption - ANS-When data is encrypted, 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
Database - ANS-A database is a collection of information that is organized so that it can
easily be accessed, managed, and updated.
, DCL - ANS-Data control language is used to control access to data stored in a
database.
DDL - ANS-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.
Definer - ANS-Definer is a MySQL term where AuthID is the same for another DBMS
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.
DML - ANS-Data manipulation language refers to the four basic operations that can and
must be performed on data stored in any DBMS: data retrieval, data update, insertion of
new records, and deletion of existing records.
E-R model - ANS-An E-R model is a data model for describing a database in an
abstract way.
embedded mode - ANS-The SELECT command is embedded within the lines of a
higher-level language program and functions as an input or "read" statement for the
program.
Entity - ANS-An entity is an object or event in our environment that we want to keep
track of.
Foreign Key - ANS-Is a field (or collection of fields) in one table that uniquely identifies a
row of another table.
Index - ANS-Used to help a DBMS find data quickly
Inner Join - ANS-Shows row that have matches in both tables
Intersection Data - ANS-Intersection Data associated with the concatenation of two
segments.
Associative Entity - ANS-An associative entity is an element of the entity-relationship
model. All relationships for the associative entity should be many.
Attribute - ANS-An attribute is a property or characteristic of an entity.
Binary relationship - ANS-A binary relationship is a relationship between two entity
types.
Candidate Key - ANS-Is any column or a combination of columns that can qualify as
unique key in database.
Cardinality - ANS-Cardinality represents the maximum number of entities that can be
involved in a particular relationship.
Cartesian product - ANS-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.
Cascade Delete - ANS-Will delete all records that reference the primary key
column subquery - ANS-Returns a single column of one or more values.
data encryption - ANS-When data is encrypted, 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
Database - ANS-A database is a collection of information that is organized so that it can
easily be accessed, managed, and updated.
, DCL - ANS-Data control language is used to control access to data stored in a
database.
DDL - ANS-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.
Definer - ANS-Definer is a MySQL term where AuthID is the same for another DBMS
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.
DML - ANS-Data manipulation language refers to the four basic operations that can and
must be performed on data stored in any DBMS: data retrieval, data update, insertion of
new records, and deletion of existing records.
E-R model - ANS-An E-R model is a data model for describing a database in an
abstract way.
embedded mode - ANS-The SELECT command is embedded within the lines of a
higher-level language program and functions as an input or "read" statement for the
program.
Entity - ANS-An entity is an object or event in our environment that we want to keep
track of.
Foreign Key - ANS-Is a field (or collection of fields) in one table that uniquely identifies a
row of another table.
Index - ANS-Used to help a DBMS find data quickly
Inner Join - ANS-Shows row that have matches in both tables
Intersection Data - ANS-Intersection Data associated with the concatenation of two
segments.
