Data Management Foundation C175 WGU ACTUAL 2024\2025
Study online at https://quizlet.com/_h5ptf3
An associative entity is an element of
the entity-relationship model. All relation-
Associative Entity
ships for the associative entity should be
many.
An attribute is a property or characteristic
Attribute
of an entity.
A binary relationship is a relationship be-
Binary relationship
tween two entity types.
Is any column or a combination of
Candidate Key columns that can qualify as unique key
in database.
Cardinality represents the maximum
Cardinality number of entities that can be involved in
a particular relationship.
Usually the result of a missing join con-
dition or a method of expanding the data
Cartesian product
of 1 table by the number of rows in the
second table.
Will delete all records that reference the
Cascade Delete
primary key
Returns a single column of one or more
column subquery
values.
When data is encrypted, it is changed,
bit by bit or character by character, into a
data encryption form that looks totally garbled. It can and
must be reconverted, or decrypted, back
to its original form to be of use.
Is a methodology for organizing attribut-
Data normalization es into tables so that redundancy among
the non-key attributes is eliminated.
Describes how often stored data is up-
Data volatility
dated.
Understanding of how much data will be
Data Volume Assessment
in a database or a table within a database
Database
1/7
, Data Management Foundation C175 WGU ACTUAL 2024\2025
Study online at https://quizlet.com/_h5ptf3
A database is a collection of information
that is organized so that it can easily be
accessed, managed, and updated.
Data control language is used to control
DCL
access to data stored in a database.
Data definition language - involves in-
structing the DBMS software on what ta-
DDL bles will be in the database, what attrib-
utes will be in the tables, which attributes
will be indexed, and so forth.
Definer is a MySQL term where AuthID
Definer
is the same for another DBMS
The act of duplicating data in a database
Denormalization for performance or the preservation of
historical information
Involves rebuilding an entire information
system or significant parts of one after
disaster recovery a catastrophic natural disaster such as a
hurricane, tornado, earthquake, building
collapse, or even a major fire.
Data manipulation language refers to
the four basic operations that can and
must be performed on data stored in any
DML
DBMS: data retrieval, data update, in-
sertion of new records, and deletion of
existing records.
An E-R model is a data model for de-
E-R model
scribing a database in an abstract way.
The SELECT command is embedded
within the lines of a higher-level language
embedded mode
program and functions as an input or
"read" statement for the program.
An entity is an object or event in our
Entity environment that we want to keep track
of.
Foreign Key
2/7
Study online at https://quizlet.com/_h5ptf3
An associative entity is an element of
the entity-relationship model. All relation-
Associative Entity
ships for the associative entity should be
many.
An attribute is a property or characteristic
Attribute
of an entity.
A binary relationship is a relationship be-
Binary relationship
tween two entity types.
Is any column or a combination of
Candidate Key columns that can qualify as unique key
in database.
Cardinality represents the maximum
Cardinality number of entities that can be involved in
a particular relationship.
Usually the result of a missing join con-
dition or a method of expanding the data
Cartesian product
of 1 table by the number of rows in the
second table.
Will delete all records that reference the
Cascade Delete
primary key
Returns a single column of one or more
column subquery
values.
When data is encrypted, it is changed,
bit by bit or character by character, into a
data encryption form that looks totally garbled. It can and
must be reconverted, or decrypted, back
to its original form to be of use.
Is a methodology for organizing attribut-
Data normalization es into tables so that redundancy among
the non-key attributes is eliminated.
Describes how often stored data is up-
Data volatility
dated.
Understanding of how much data will be
Data Volume Assessment
in a database or a table within a database
Database
1/7
, Data Management Foundation C175 WGU ACTUAL 2024\2025
Study online at https://quizlet.com/_h5ptf3
A database is a collection of information
that is organized so that it can easily be
accessed, managed, and updated.
Data control language is used to control
DCL
access to data stored in a database.
Data definition language - involves in-
structing the DBMS software on what ta-
DDL bles will be in the database, what attrib-
utes will be in the tables, which attributes
will be indexed, and so forth.
Definer is a MySQL term where AuthID
Definer
is the same for another DBMS
The act of duplicating data in a database
Denormalization for performance or the preservation of
historical information
Involves rebuilding an entire information
system or significant parts of one after
disaster recovery a catastrophic natural disaster such as a
hurricane, tornado, earthquake, building
collapse, or even a major fire.
Data manipulation language refers to
the four basic operations that can and
must be performed on data stored in any
DML
DBMS: data retrieval, data update, in-
sertion of new records, and deletion of
existing records.
An E-R model is a data model for de-
E-R model
scribing a database in an abstract way.
The SELECT command is embedded
within the lines of a higher-level language
embedded mode
program and functions as an input or
"read" statement for the program.
An entity is an object or event in our
Entity environment that we want to keep track
of.
Foreign Key
2/7
