WGU C170 Data Management SQL Problem Solving
Questions and ChatGPT' Solutions 2024/2025
Structural Constraints: - correct answer Rules that apply to all relational databases and
dictate the structure of data.
Business Policies: - correct answer Specific rules for a given database and application
that govern the data.
NULL - correct answer Represents missing data in a special value format.
Operator - correct answer A symbol that calculates a value based on one or more
operands.
IS NULL - correct answer A set of key words that returns "true" when compared to
NULL, used in place of the equal sign (=) to select rows containing NULL values.
Aggregate function - correct answer A function that performs mathematical operations
on numeric values from multiple rows, only including rows selected by the WHERE
clause.
Truth tables - correct answer Define the value of logical expressions containing NULL
operands.
Primary key - correct answer A single column or a group of columns used to identify a
specific row in a database.
Simple primary key - correct answer Consists of only one column.
Composite primary key - correct answer Made up of multiple columns.
,Minimal primary key - correct answer All columns are required for uniqueness.
Foreign key - correct answer A single column or a group of columns that refer to a
primary key in another table.
Fully NULL Foreign Key - correct answer A type of foreign key where all columns are
set to NULL.
Referential Integrity - correct answer The requirement that all foreign key values must
match some primary key value or be fully NULL.
Restrict - correct answer A constraint that prevents an insert, update, or delete that
violates referential integrity.
Set NULL - correct answer A constraint that sets invalid foreign keys to NULL.
Set Default - correct answer A constraint that sets invalid foreign keys to a default
primary key value.
Cascade - correct answer A constraint that propagates primary key changes to foreign
keys.
Redundancy - correct answer The repetition of related values in a table.
Dependence - correct answer The relationship between two columns where one
depends on the other.
Normal Forms - correct answer Rules for designing tables with less redundancy.
Functional Dependence - correct answer The dependence of one column on another.
, Multivalued Dependence - correct answer A type of dependence between three or
more columns.
Join Dependence - correct answer A type of dependence between three or more
columns.
First Normal Form - correct answer A table design where all non-key columns depend
on the primary key.
Second Normal Form - correct answer A table design where all non-key columns
depend on the whole primary key.
Candidate Key - correct answer A column or group of columns that is unique and
minimal.
Non-Key - correct answer A column that is not contained in a candidate key.
Third Normal Form - correct answer A table design where whenever a non-key column
depends on another column, the latter is unique.
Boyce-Codd Normal Form - correct answer A table design where whenever a column
depends on another column, the latter is unique.
Structured Query Language - correct answer A high-level computer language for
storing, manipulating, and retrieving data in a relational database.
SQL Statement - correct answer A complete command composed of one or more
clauses.
SQL Clause - correct answer A group of SQL keywords and table names, column
names, and conditions.
Questions and ChatGPT' Solutions 2024/2025
Structural Constraints: - correct answer Rules that apply to all relational databases and
dictate the structure of data.
Business Policies: - correct answer Specific rules for a given database and application
that govern the data.
NULL - correct answer Represents missing data in a special value format.
Operator - correct answer A symbol that calculates a value based on one or more
operands.
IS NULL - correct answer A set of key words that returns "true" when compared to
NULL, used in place of the equal sign (=) to select rows containing NULL values.
Aggregate function - correct answer A function that performs mathematical operations
on numeric values from multiple rows, only including rows selected by the WHERE
clause.
Truth tables - correct answer Define the value of logical expressions containing NULL
operands.
Primary key - correct answer A single column or a group of columns used to identify a
specific row in a database.
Simple primary key - correct answer Consists of only one column.
Composite primary key - correct answer Made up of multiple columns.
,Minimal primary key - correct answer All columns are required for uniqueness.
Foreign key - correct answer A single column or a group of columns that refer to a
primary key in another table.
Fully NULL Foreign Key - correct answer A type of foreign key where all columns are
set to NULL.
Referential Integrity - correct answer The requirement that all foreign key values must
match some primary key value or be fully NULL.
Restrict - correct answer A constraint that prevents an insert, update, or delete that
violates referential integrity.
Set NULL - correct answer A constraint that sets invalid foreign keys to NULL.
Set Default - correct answer A constraint that sets invalid foreign keys to a default
primary key value.
Cascade - correct answer A constraint that propagates primary key changes to foreign
keys.
Redundancy - correct answer The repetition of related values in a table.
Dependence - correct answer The relationship between two columns where one
depends on the other.
Normal Forms - correct answer Rules for designing tables with less redundancy.
Functional Dependence - correct answer The dependence of one column on another.
, Multivalued Dependence - correct answer A type of dependence between three or
more columns.
Join Dependence - correct answer A type of dependence between three or more
columns.
First Normal Form - correct answer A table design where all non-key columns depend
on the primary key.
Second Normal Form - correct answer A table design where all non-key columns
depend on the whole primary key.
Candidate Key - correct answer A column or group of columns that is unique and
minimal.
Non-Key - correct answer A column that is not contained in a candidate key.
Third Normal Form - correct answer A table design where whenever a non-key column
depends on another column, the latter is unique.
Boyce-Codd Normal Form - correct answer A table design where whenever a column
depends on another column, the latter is unique.
Structured Query Language - correct answer A high-level computer language for
storing, manipulating, and retrieving data in a relational database.
SQL Statement - correct answer A complete command composed of one or more
clauses.
SQL Clause - correct answer A group of SQL keywords and table names, column
names, and conditions.
