WGU D427 Data Management - Applications
Exam | Questions and Answers | Verified
Solutions | 2026 Edition | Pass Guaranteed
Save
Terms in this set (263)
database model A database model is a conceptual framework for
database systems, with three parts:
- Data structures that prescribe how data is
organized.
- Operations that manipulate data structures.
- Rules that govern valid data.
relational model The relational model is a database model based on
a tabular data structure. The model was published
in 1970 by E. F. Codd of IBM and released in
commercial products around 1980. The data
structure, operations, and rules are standardized in
SQL, the universal query language of relational
databases.
big data The rise of the internet in the 1990s generated big
data, characterized by unprecedented data
volumes and rapidly changing data structures.
set A set is an unordered collection of elements
enclosed in braces.
, tuple A tuple is an ordered collection of elements
enclosed in parentheses.
table A table has a name, a fixed tuple of columns, and a
varying set of rows.
column A column has a name and a data type.
row A row is an unnamed tuple of values. Each value
corresponds to a column and belongs to the
column's data type.
data type A data type is a named set of values, from which
column values are drawn.
relational algebra These operations are collectively called relational
algebra and are the theoretical foundation of the
SQL language.
Relational rules Relational rules are part of the relational model
and govern data in every relational database.
Business rules Business rules are based on business policy and
specific to a particular database.
constraints Relational rules are implemented as SQL
constraints and enforced by the database system.
Structured Query Language / SQL Structured Query Language (SQL) is a high-level
computer language for storing, manipulating, and
retrieving data.
Exam | Questions and Answers | Verified
Solutions | 2026 Edition | Pass Guaranteed
Save
Terms in this set (263)
database model A database model is a conceptual framework for
database systems, with three parts:
- Data structures that prescribe how data is
organized.
- Operations that manipulate data structures.
- Rules that govern valid data.
relational model The relational model is a database model based on
a tabular data structure. The model was published
in 1970 by E. F. Codd of IBM and released in
commercial products around 1980. The data
structure, operations, and rules are standardized in
SQL, the universal query language of relational
databases.
big data The rise of the internet in the 1990s generated big
data, characterized by unprecedented data
volumes and rapidly changing data structures.
set A set is an unordered collection of elements
enclosed in braces.
, tuple A tuple is an ordered collection of elements
enclosed in parentheses.
table A table has a name, a fixed tuple of columns, and a
varying set of rows.
column A column has a name and a data type.
row A row is an unnamed tuple of values. Each value
corresponds to a column and belongs to the
column's data type.
data type A data type is a named set of values, from which
column values are drawn.
relational algebra These operations are collectively called relational
algebra and are the theoretical foundation of the
SQL language.
Relational rules Relational rules are part of the relational model
and govern data in every relational database.
Business rules Business rules are based on business policy and
specific to a particular database.
constraints Relational rules are implemented as SQL
constraints and enforced by the database system.
Structured Query Language / SQL Structured Query Language (SQL) is a high-level
computer language for storing, manipulating, and
retrieving data.
