C170 DATA MANAGEMENT APPLICATIONS
VHT2 WGU NORA'S BAGEL BIN DATABASE
BLUEPRINTS ACTUAL EXAM PAPER 2026
QUESTIONS WITH ANSWERS GRADED A+
⩥ Second Normal Form. Answer: - when all non-key columns depend
on the whole primary key
- cannot depend on part of a composite primary key
- a table with a simple primary key is automatically in second normal
form
⩥ A table with a simple primary key must be in what normal form?.
Answer: - second normal form or higher
⩥ Third Normal Form. Answer: - when all non-key columns depend on
the key, the whole key, and nothing but the key
⩥ Violation of Third Normal Form. Answer: - a non-key column
depends on a column that is not unique
⩥ Boyce-Codd Normal Form. Answer: - whenever column A depends on
column B, then B is unique
- same as Third Normal Form, except "non-key" is removed
,⩥ A table has:
- columns A, B, C, D
- candidate key (A, C, D)
- primary key (A, C, D)
- dependency D → B (in addition to dependencies on candidate keys)
What is the normal form of the table?. Answer: - First Normal Form
- the table has one candidate key, which is also a primary key
- any table with a primary key is in FIRST nf
- the non-key column B does not depend on the whole primary key...so
not in SECOND normal form
⩥ A table has:
- columns A, B, C, D
- candidate keys (C, D) and A
- primary key (C, D)
- dependencies on (C, D) and A only
What is the normal form of the table?. Answer: - Boyce-Codd
- The table is in Boyce-Codd normal form since all dependencies are on
candidate keys.
, - Therefore, all dependencies are on unique columns.
⩥ A table has:
- columns A, B, C, D
- candidate key (A, B, D)
- primary key (A, B, D)
- dependency C → D (in addition to dependencies on candidate keys)
What is the normal form of the table?. Answer: - THIRD
- The table is in third normal form since non-key columns depend only
on unique columns.
- D is not a non-key column.
- The table is not in Boyce-Codd normal form since D depends on the
non-unique column C.
- Primary keys must be minimal, so no column in a composite primary
key can be unique.
- Therefore, C is not unique.
⩥ A table has:
- columns A, B, C, D
- candidate keys D and (A, C)
- primary key (A, C)
- dependency B → C (in addition to dependencies on candidate keys)
VHT2 WGU NORA'S BAGEL BIN DATABASE
BLUEPRINTS ACTUAL EXAM PAPER 2026
QUESTIONS WITH ANSWERS GRADED A+
⩥ Second Normal Form. Answer: - when all non-key columns depend
on the whole primary key
- cannot depend on part of a composite primary key
- a table with a simple primary key is automatically in second normal
form
⩥ A table with a simple primary key must be in what normal form?.
Answer: - second normal form or higher
⩥ Third Normal Form. Answer: - when all non-key columns depend on
the key, the whole key, and nothing but the key
⩥ Violation of Third Normal Form. Answer: - a non-key column
depends on a column that is not unique
⩥ Boyce-Codd Normal Form. Answer: - whenever column A depends on
column B, then B is unique
- same as Third Normal Form, except "non-key" is removed
,⩥ A table has:
- columns A, B, C, D
- candidate key (A, C, D)
- primary key (A, C, D)
- dependency D → B (in addition to dependencies on candidate keys)
What is the normal form of the table?. Answer: - First Normal Form
- the table has one candidate key, which is also a primary key
- any table with a primary key is in FIRST nf
- the non-key column B does not depend on the whole primary key...so
not in SECOND normal form
⩥ A table has:
- columns A, B, C, D
- candidate keys (C, D) and A
- primary key (C, D)
- dependencies on (C, D) and A only
What is the normal form of the table?. Answer: - Boyce-Codd
- The table is in Boyce-Codd normal form since all dependencies are on
candidate keys.
, - Therefore, all dependencies are on unique columns.
⩥ A table has:
- columns A, B, C, D
- candidate key (A, B, D)
- primary key (A, B, D)
- dependency C → D (in addition to dependencies on candidate keys)
What is the normal form of the table?. Answer: - THIRD
- The table is in third normal form since non-key columns depend only
on unique columns.
- D is not a non-key column.
- The table is not in Boyce-Codd normal form since D depends on the
non-unique column C.
- Primary keys must be minimal, so no column in a composite primary
key can be unique.
- Therefore, C is not unique.
⩥ A table has:
- columns A, B, C, D
- candidate keys D and (A, C)
- primary key (A, C)
- dependency B → C (in addition to dependencies on candidate keys)
