10/5/25, 11:38 AM WGU D427 Data Management - Applications Flashcards | Quizlet
Science Computer Science
WGU D427 Data Management - Applications
Leave the first rating
Save
Students also studied
Flashcard sets Study guides Practice tests
AP Computer Science Principles Uni... Networking Appliances, Application... ACCY 530 - Auditing Operating Syst... Chapte
16 terms 25 terms 69 terms 26 terms
abhadoria Preview Jessica_Lawrence143 Preview meganlbundren Preview sols
Terms in this set (263)
A database model is a conceptual framework for database systems, with three parts:
- Data structures that prescribe how data is organized.
database model
- Operations that manipulate data structures.
- Rules that govern valid data.
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
relational model
products around 1980. The data structure, operations, and rules are standardized in
SQL, the universal query language of relational databases.
The rise of the internet in the 1990s generated big data, characterized by
big data
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.
A row is an unnamed tuple of values. Each value corresponds to a column and
row
belongs to the column's data type.
data type A data type is a named set of values, from which column values are drawn.
These operations are collectively called relational algebra and are the theoretical
relational algebra
foundation of the SQL language.
Relational rules are part of the relational model and govern data in every relational
Relational rules
database.
Business rules Business rules are based on business policy and specific to a particular database.
https://quizlet.com/927135592/wgu-d427-data-management-applications-flash-cards/ 1/5
, 10/5/25, 11:38 AM WGU D427 Data Management - Applications Flashcards | Quizlet
Relational rules are implemented as SQL constraints and enforced by the database
constraints
system.
Structured Query Language (SQL) is a high-level computer language for storing,
Structured Query Language / SQL
manipulating, and retrieving data.
statement An SQL statement is a complete command composed of one or more clauses.
A clause groups SQL keywords like SELECT, FROM, and WHERE with table names
clause
like City, column names like Name, and conditions like Population > 100000.
Data Definition Language Data Definition Language (DDL) defines the structure of the database.
Data Query Language Data Query Language (DQL) retrieves data from the database.
Data Manipulation Language Data Manipulation Language (DML) manipulates data stored in a database.
Data Control Language Data Control Language (DCL) controls database user access.
Data Transaction Language Data Transaction Language (DTL) manages database transactions.
A database system instance is a single executing copy of a database system.
Personal computers usually run just one instance of a database system. Shared
database system instance
computers, such as computers used for cloud services, usually run multiple instances
of a database system.
CREATE DATABASE DatabaseName CREATE DATABASE DatabaseName creates a new database.
DROP DATABASE DatabaseName deletes a database, including all tables in the
DROP DATABASE DatabaseName
database.
USE DatabaseName selects a default database for use in subsequent SQL
USE DatabaseName
statements.
SHOW DATABASES SHOW DATABASES lists all databases in the database system instance.
SHOW TABLES SHOW TABLES lists all tables in the default database.
SHOW COLUMNS FROM TableName lists all columns in the TableName table of the
SHOW COLUMNS FROM TableName
default database.
SHOW CREATE TABLE TableName shows the CREATE TABLE statement for the
SHOW CREATE TABLE TableName
TableName table of the default database.
table A table has a name, a fixed sequence of columns, and a varying set of rows.
column A column has a name and a data type.
A row is an unnamed sequence of values. Each value corresponds to a column and
row
belongs to the column's data type.
cell A cell is a single column of a single row.
empty table A table without rows is called an empty table.
data independence Rule 4 is called data independence.
The CREATE TABLE statement creates a new table by specifying the table name,
CREATE TABLE
column names, and column data types.
The DROP TABLE statement deletes a table, along with all the table's rows, from a
DROP TABLE
database.
ALTER TABLE The ALTER TABLE statement adds, deletes, or modifies columns on an existing table.
data type A data type is a named set of values from which column values are drawn.
Integer Integer data types represent positive and negative integers.
Decimal Decimal data types represent numbers with fractional values.
https://quizlet.com/927135592/wgu-d427-data-management-applications-flash-cards/ 2/5
Science Computer Science
WGU D427 Data Management - Applications
Leave the first rating
Save
Students also studied
Flashcard sets Study guides Practice tests
AP Computer Science Principles Uni... Networking Appliances, Application... ACCY 530 - Auditing Operating Syst... Chapte
16 terms 25 terms 69 terms 26 terms
abhadoria Preview Jessica_Lawrence143 Preview meganlbundren Preview sols
Terms in this set (263)
A database model is a conceptual framework for database systems, with three parts:
- Data structures that prescribe how data is organized.
database model
- Operations that manipulate data structures.
- Rules that govern valid data.
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
relational model
products around 1980. The data structure, operations, and rules are standardized in
SQL, the universal query language of relational databases.
The rise of the internet in the 1990s generated big data, characterized by
big data
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.
A row is an unnamed tuple of values. Each value corresponds to a column and
row
belongs to the column's data type.
data type A data type is a named set of values, from which column values are drawn.
These operations are collectively called relational algebra and are the theoretical
relational algebra
foundation of the SQL language.
Relational rules are part of the relational model and govern data in every relational
Relational rules
database.
Business rules Business rules are based on business policy and specific to a particular database.
https://quizlet.com/927135592/wgu-d427-data-management-applications-flash-cards/ 1/5
, 10/5/25, 11:38 AM WGU D427 Data Management - Applications Flashcards | Quizlet
Relational rules are implemented as SQL constraints and enforced by the database
constraints
system.
Structured Query Language (SQL) is a high-level computer language for storing,
Structured Query Language / SQL
manipulating, and retrieving data.
statement An SQL statement is a complete command composed of one or more clauses.
A clause groups SQL keywords like SELECT, FROM, and WHERE with table names
clause
like City, column names like Name, and conditions like Population > 100000.
Data Definition Language Data Definition Language (DDL) defines the structure of the database.
Data Query Language Data Query Language (DQL) retrieves data from the database.
Data Manipulation Language Data Manipulation Language (DML) manipulates data stored in a database.
Data Control Language Data Control Language (DCL) controls database user access.
Data Transaction Language Data Transaction Language (DTL) manages database transactions.
A database system instance is a single executing copy of a database system.
Personal computers usually run just one instance of a database system. Shared
database system instance
computers, such as computers used for cloud services, usually run multiple instances
of a database system.
CREATE DATABASE DatabaseName CREATE DATABASE DatabaseName creates a new database.
DROP DATABASE DatabaseName deletes a database, including all tables in the
DROP DATABASE DatabaseName
database.
USE DatabaseName selects a default database for use in subsequent SQL
USE DatabaseName
statements.
SHOW DATABASES SHOW DATABASES lists all databases in the database system instance.
SHOW TABLES SHOW TABLES lists all tables in the default database.
SHOW COLUMNS FROM TableName lists all columns in the TableName table of the
SHOW COLUMNS FROM TableName
default database.
SHOW CREATE TABLE TableName shows the CREATE TABLE statement for the
SHOW CREATE TABLE TableName
TableName table of the default database.
table A table has a name, a fixed sequence of columns, and a varying set of rows.
column A column has a name and a data type.
A row is an unnamed sequence of values. Each value corresponds to a column and
row
belongs to the column's data type.
cell A cell is a single column of a single row.
empty table A table without rows is called an empty table.
data independence Rule 4 is called data independence.
The CREATE TABLE statement creates a new table by specifying the table name,
CREATE TABLE
column names, and column data types.
The DROP TABLE statement deletes a table, along with all the table's rows, from a
DROP TABLE
database.
ALTER TABLE The ALTER TABLE statement adds, deletes, or modifies columns on an existing table.
data type A data type is a named set of values from which column values are drawn.
Integer Integer data types represent positive and negative integers.
Decimal Decimal data types represent numbers with fractional values.
https://quizlet.com/927135592/wgu-d427-data-management-applications-flash-cards/ 2/5
