WGU C170 VHT2 TASK 1 ACTUAL EXAM
PAPER 2026 QUESTIONS WITH ANSWERS
GRADED A+
⩥ Second Normal Form (2NF). Answer: • no non-key attribute depends
on only a portion of the primary key (i.e. contains no partial
dependencies)
• no repeating groups
• atomic values in each column
• no duplicate records.
⩥ Third Normal Form (3NF) or Boyce-Codd normal form (BCNF).
Answer: • the only determinants it contains are candidate keys.
• typically used in RDB
• no non-key attribute depends on only a portion of the primary key.
• no repeating groups
• atomic values in each column
• no duplicate records.
⩥ To correct anomalies in a database,. Answer: you convert data into
multiple tables that progress through a sequence of normal forms
, ⩥ Decomposition. Answer: normalizing the table by breaking down the
table into progressively finer levels of details
⩥ Fourth Normal Form (4NF). Answer: • contains no multivalued
dependencies.
• the only determinants it contains are candidate keys.
• typically used in RDB
• no non-key attribute depends on only a portion of the primary key.
• no repeating groups
• atomic values in each column
• no duplicate records.
⩥ If you cannot define a consistent pattern to use with a programming
algorithm to solve the problem,. Answer: you're faced with the drudgery
of manually updating the data
⩥ atomic value. Answer: A piece of data that cannot be meaningfully
divided.
⩥ candidate key. Answer: A column (or field) in a table that can
uniquely identify a database record without referring to any other data.
PAPER 2026 QUESTIONS WITH ANSWERS
GRADED A+
⩥ Second Normal Form (2NF). Answer: • no non-key attribute depends
on only a portion of the primary key (i.e. contains no partial
dependencies)
• no repeating groups
• atomic values in each column
• no duplicate records.
⩥ Third Normal Form (3NF) or Boyce-Codd normal form (BCNF).
Answer: • the only determinants it contains are candidate keys.
• typically used in RDB
• no non-key attribute depends on only a portion of the primary key.
• no repeating groups
• atomic values in each column
• no duplicate records.
⩥ To correct anomalies in a database,. Answer: you convert data into
multiple tables that progress through a sequence of normal forms
, ⩥ Decomposition. Answer: normalizing the table by breaking down the
table into progressively finer levels of details
⩥ Fourth Normal Form (4NF). Answer: • contains no multivalued
dependencies.
• the only determinants it contains are candidate keys.
• typically used in RDB
• no non-key attribute depends on only a portion of the primary key.
• no repeating groups
• atomic values in each column
• no duplicate records.
⩥ If you cannot define a consistent pattern to use with a programming
algorithm to solve the problem,. Answer: you're faced with the drudgery
of manually updating the data
⩥ atomic value. Answer: A piece of data that cannot be meaningfully
divided.
⩥ candidate key. Answer: A column (or field) in a table that can
uniquely identify a database record without referring to any other data.
