WGU D427 Data Management – Applications OA
Actual Exam 2026/2027 | Questions 1-25 with Verified
Answers | 100% Correct | Pass Guaranteed
SECTION 1: Database Design & Normalization (8 Questions)
Q1 (Screenshot Description):
A table named CustomerOrders is shown with columns:
OrderID (PK), CustomerID, CustomerName, OrderDate, ProductID, ProductName,
Quantity, UnitPrice, CustomerEmail.
Sample rows reveal that CustomerID 101 appears three times with identical
CustomerName but two different CustomerEmail values.
Which normal-form violation is demonstrated?
A. No primary key
B. Transitive dependency (3NF violation)
C. Partial dependency (2NF violation)
D. Repeating groups (1NF violation)
Correct Answer: B
Rationale (Competency 427.1.3 – Apply normalization rules):
,CustomerEmail is not dependent on the primary key (OrderID); it depends on
CustomerID, which is itself a non-key attribute. This creates the transitive dependency
OrderID → CustomerID → CustomerEmail, violating 3NF. Splitting the table into
Customers(CustomerID, CustomerName, CustomerEmail) and Orders(OrderID,
CustomerID, OrderDate, …) removes the anomaly and prevents update inconsistencies.
Q2 (Screenshot Description):
An ER diagram shows two entities:
● EMPLOYEE (EmpID, FullName, DeptName, DeptLocation)
● PROJECT (ProjID, ProjName, DeptName)
Relationship “Works-On” is many-to-many between EMPLOYEE and PROJECT
with no attribute.
Which redesign is required to achieve 3NF?
A. Add DeptID as a surrogate key in EMPLOYEE
B. Create separate DEPARTMENT(DeptID, DeptName, DeptLocation) and link with FK
C. Move ProjName into EMPLOYEE
D. Combine both entities into one WORKON table
Correct Answer: B
Rationale (Competency 427.1.2 – Design normalized structures):
DeptLocation is transitively dependent on EmpID through DeptName. Creating a
DEPARTMENT table and replacing DeptName/DeptLocation in EMPLOYEE and
PROJECT with DeptID eliminates transitive dependencies and achieves 3NF.
, Q3 (Screenshot Description):
Relation R(A,B,C,D) with FDs: A→B, B→C, C→D.
What is the highest NF satisfied?
A. 1NF
B. 2NF
C. 3NF
D. BCNF
Correct Answer: B
Rationale: A is the sole candidate key. There are no partial dependencies (2NF
satisfied), but the chain A→B→C→D creates transitive dependencies (C→D where both
C and D are non-prime), violating 3NF.
Q4 (Screenshot Description):
Table STUDENT_COURSE
(StuID, StuName, CourseID, CourseTitle, Grade, ProfessorName)
Functional dependencies:
StuID → StuName
CourseID → CourseTitle
StuID,CourseID → Grade
CourseID → ProfessorName
Actual Exam 2026/2027 | Questions 1-25 with Verified
Answers | 100% Correct | Pass Guaranteed
SECTION 1: Database Design & Normalization (8 Questions)
Q1 (Screenshot Description):
A table named CustomerOrders is shown with columns:
OrderID (PK), CustomerID, CustomerName, OrderDate, ProductID, ProductName,
Quantity, UnitPrice, CustomerEmail.
Sample rows reveal that CustomerID 101 appears three times with identical
CustomerName but two different CustomerEmail values.
Which normal-form violation is demonstrated?
A. No primary key
B. Transitive dependency (3NF violation)
C. Partial dependency (2NF violation)
D. Repeating groups (1NF violation)
Correct Answer: B
Rationale (Competency 427.1.3 – Apply normalization rules):
,CustomerEmail is not dependent on the primary key (OrderID); it depends on
CustomerID, which is itself a non-key attribute. This creates the transitive dependency
OrderID → CustomerID → CustomerEmail, violating 3NF. Splitting the table into
Customers(CustomerID, CustomerName, CustomerEmail) and Orders(OrderID,
CustomerID, OrderDate, …) removes the anomaly and prevents update inconsistencies.
Q2 (Screenshot Description):
An ER diagram shows two entities:
● EMPLOYEE (EmpID, FullName, DeptName, DeptLocation)
● PROJECT (ProjID, ProjName, DeptName)
Relationship “Works-On” is many-to-many between EMPLOYEE and PROJECT
with no attribute.
Which redesign is required to achieve 3NF?
A. Add DeptID as a surrogate key in EMPLOYEE
B. Create separate DEPARTMENT(DeptID, DeptName, DeptLocation) and link with FK
C. Move ProjName into EMPLOYEE
D. Combine both entities into one WORKON table
Correct Answer: B
Rationale (Competency 427.1.2 – Design normalized structures):
DeptLocation is transitively dependent on EmpID through DeptName. Creating a
DEPARTMENT table and replacing DeptName/DeptLocation in EMPLOYEE and
PROJECT with DeptID eliminates transitive dependencies and achieves 3NF.
, Q3 (Screenshot Description):
Relation R(A,B,C,D) with FDs: A→B, B→C, C→D.
What is the highest NF satisfied?
A. 1NF
B. 2NF
C. 3NF
D. BCNF
Correct Answer: B
Rationale: A is the sole candidate key. There are no partial dependencies (2NF
satisfied), but the chain A→B→C→D creates transitive dependencies (C→D where both
C and D are non-prime), violating 3NF.
Q4 (Screenshot Description):
Table STUDENT_COURSE
(StuID, StuName, CourseID, CourseTitle, Grade, ProfessorName)
Functional dependencies:
StuID → StuName
CourseID → CourseTitle
StuID,CourseID → Grade
CourseID → ProfessorName
