WGU C170 Data Management SQL Problem Solving Questions and ChatGPT' Solutions 2024/2025

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.