C170 DATA MANAGEMENT APPLICATIONS
VHT2 WGU NORA'S BAGEL BIN DATABASE
BLUEPRINTS EXAM SCRIPT 2026
COMPREHENSIVE QUESTIONS WITH
SOLUTIONS GRADED A+
⩥ ID Name Salary
2538Lisa Ellison45000
5384Sam Snead30500
6381Maria Rodriguez92300
1)
Name is a good primary key. Answer: false
New employees with the same name might be added to the table. Since
the Name column might contain duplicate values, the Name column is
not a good primary key.
⩥ A new employee can be added without an ID value. Answer: false
Primary keys may not be NULL. When a new employee is added to the
table, the database requires a non-NULL value for ID.
⩥ A new employee can be added with ID 5384.. Answer: Sam Snead
already has ID 5384. ID is the primary key, and duplicate primary key
values are not allowed.
, ⩥ compsite primery key. Answer: Sometimes multiple columns are
necessary to identify a row. A simple primary key consists of a single
column. A composite primary key consists of multiple columns.
Composite primary keys are denoted with parentheses. Ex: (ColumnA,
ColumnB).
⩥ minima; primary key. Answer: In a minimal primary key, all columns
are necessary for uniqueness. When any column is removed from a
minimal composite primary key, the resulting simple or composite
column is no longer unique.
⩥ Can (ID, Relationship) be the primary key of Family?. Answer: (ID,
Relationship) cannot be the primary key because (6381, Daughter) is
repeated. Composite primary keys must be unique.
⩥ The primary key of the PhoneNumber table is not indicated with a
solid circle. What is the primary key of PhoneNumber?. Answer:
(AreaCode, Exchange, Number) is unique, non-null, and minimal, so
(AreaCode, Exchange, Number) is a composite primary key.
Occasionally, a primary key includes all columns in a table.
⩥ Foreign Key. Answer: A foreign key is a column, or group of columns,
that refer to a primary key. Non-NULL foreign key values must match
some value of the primary key. The data types of the foreign and primary
keys must be the same, but the names may be different. In this material,
an empty circle (○) precedes foreign keys in table examples.
VHT2 WGU NORA'S BAGEL BIN DATABASE
BLUEPRINTS EXAM SCRIPT 2026
COMPREHENSIVE QUESTIONS WITH
SOLUTIONS GRADED A+
⩥ ID Name Salary
2538Lisa Ellison45000
5384Sam Snead30500
6381Maria Rodriguez92300
1)
Name is a good primary key. Answer: false
New employees with the same name might be added to the table. Since
the Name column might contain duplicate values, the Name column is
not a good primary key.
⩥ A new employee can be added without an ID value. Answer: false
Primary keys may not be NULL. When a new employee is added to the
table, the database requires a non-NULL value for ID.
⩥ A new employee can be added with ID 5384.. Answer: Sam Snead
already has ID 5384. ID is the primary key, and duplicate primary key
values are not allowed.
, ⩥ compsite primery key. Answer: Sometimes multiple columns are
necessary to identify a row. A simple primary key consists of a single
column. A composite primary key consists of multiple columns.
Composite primary keys are denoted with parentheses. Ex: (ColumnA,
ColumnB).
⩥ minima; primary key. Answer: In a minimal primary key, all columns
are necessary for uniqueness. When any column is removed from a
minimal composite primary key, the resulting simple or composite
column is no longer unique.
⩥ Can (ID, Relationship) be the primary key of Family?. Answer: (ID,
Relationship) cannot be the primary key because (6381, Daughter) is
repeated. Composite primary keys must be unique.
⩥ The primary key of the PhoneNumber table is not indicated with a
solid circle. What is the primary key of PhoneNumber?. Answer:
(AreaCode, Exchange, Number) is unique, non-null, and minimal, so
(AreaCode, Exchange, Number) is a composite primary key.
Occasionally, a primary key includes all columns in a table.
⩥ Foreign Key. Answer: A foreign key is a column, or group of columns,
that refer to a primary key. Non-NULL foreign key values must match
some value of the primary key. The data types of the foreign and primary
keys must be the same, but the names may be different. In this material,
an empty circle (○) precedes foreign keys in table examples.
