WGU C170 PROJECT COMPLETE SOLUTION 2026/2027 |
Performance Assessment | Database Applications | Pass
Guaranteed - A+ Graded
[Section 1: Project Scenario Analysis & Business Requirements (Q1-10)]
Q1. A C170 PA project scenario describes a local bookstore needing to track inventory,
sales, and customer loyalty programs. Which stakeholder group would be MOST critical
to interview during the requirements gathering phase?
A. The bookstore's social media marketing team
B. The bookstore owner and floor managers [CORRECT]
C. The bookstore's website hosting provider
D. The local newspaper advertising department
Rationale: The owner and floor managers possess direct operational knowledge of
inventory workflows, sales processes, and loyalty program rules. Other options
represent peripheral stakeholders lacking direct business process knowledge.
Correct Answer: B
Q2. During requirements extraction for a university course registration system, which
document would BEST capture business rules such as "a student cannot register for
more than 18 credit hours per semester"?
A. Entity-Relationship Diagram
B. Data Dictionary
,C. Business Rules Documentation [CORRECT]
D. Network Topology Diagram
Rationale: Business rules documentation explicitly captures constraints, policies, and
operational rules. While data dictionaries describe attributes, they don't capture
behavioral rules.
Correct Answer: C
Q3. A project scenario for a medical clinic states: "Each doctor can have multiple
patients, but each patient is assigned to exactly one primary doctor." What is missing
from this requirement that would cause PA failure?
A. The doctor's salary information
B. The cardinality notation and participation constraints [CORRECT]
C. The clinic's operating hours
D. The patient's insurance provider
Rationale: PA rubric requires explicit cardinality (1:N) and participation constraints
(total/partial). Missing these results in incomplete relationship resolution and rubric
failure.
Correct Answer: B
Q4. In a library management system scenario, which data requirement would be
classified as a derived attribute rather than a base attribute?
A. Book ISBN number
,B. Member's date of birth
C. Number of books currently checked out by a member [CORRECT]
D. Book publication date
Rationale: The count of checked-out books is calculated from loan records (derived),
while ISBN, DOB, and publication date are directly stored base attributes.
Correct Answer: C
Q5. When documenting assumptions for a C170 PA project, which statement represents
a VALID assumption?
A. "The database will never need backup procedures."
B. "All customer phone numbers follow the North American format." [CORRECT]
C. "The system will prevent all possible data entry errors."
D. "No future enhancements will be required after deployment."
Rationale: Valid assumptions are realistic, verifiable, and scope-defining. Phone format
assumptions are common and testable, while others are unrealistic or scope-creeping.
Correct Answer: B
Q6. A scenario describes an e-commerce system where "orders contain products." What
critical entity is MISSING from this incomplete description that would prevent proper
ERD development?
A. Order Status
, B. Order Line Item (junction/associative entity) [CORRECT]
C. Product Category
D. Customer Review
Rationale: The M:N relationship between Orders and Products requires an associative
entity (Order Line Item) to properly model quantity, price at time of order, etc.
Correct Answer: B
Q7. Which stakeholder concern would MOST likely drive the need for a "Supplier" entity
in a retail inventory database?
A. Marketing wants to send promotional emails
B. Purchasing needs to track which supplier provided each product [CORRECT]
C. HR needs to manage employee benefits
D. Finance wants to calculate sales tax
Rationale: Supplier entity directly addresses purchasing department's need to trace
product sourcing, manage reorder points, and evaluate supplier performance.
Correct Answer: B
Q8. During scenario analysis for a rental property system, which business rule would
require a CHECK constraint at the database level?
A. Each property must have a unique address
B. Rental rate must be greater than zero [CORRECT]
Performance Assessment | Database Applications | Pass
Guaranteed - A+ Graded
[Section 1: Project Scenario Analysis & Business Requirements (Q1-10)]
Q1. A C170 PA project scenario describes a local bookstore needing to track inventory,
sales, and customer loyalty programs. Which stakeholder group would be MOST critical
to interview during the requirements gathering phase?
A. The bookstore's social media marketing team
B. The bookstore owner and floor managers [CORRECT]
C. The bookstore's website hosting provider
D. The local newspaper advertising department
Rationale: The owner and floor managers possess direct operational knowledge of
inventory workflows, sales processes, and loyalty program rules. Other options
represent peripheral stakeholders lacking direct business process knowledge.
Correct Answer: B
Q2. During requirements extraction for a university course registration system, which
document would BEST capture business rules such as "a student cannot register for
more than 18 credit hours per semester"?
A. Entity-Relationship Diagram
B. Data Dictionary
,C. Business Rules Documentation [CORRECT]
D. Network Topology Diagram
Rationale: Business rules documentation explicitly captures constraints, policies, and
operational rules. While data dictionaries describe attributes, they don't capture
behavioral rules.
Correct Answer: C
Q3. A project scenario for a medical clinic states: "Each doctor can have multiple
patients, but each patient is assigned to exactly one primary doctor." What is missing
from this requirement that would cause PA failure?
A. The doctor's salary information
B. The cardinality notation and participation constraints [CORRECT]
C. The clinic's operating hours
D. The patient's insurance provider
Rationale: PA rubric requires explicit cardinality (1:N) and participation constraints
(total/partial). Missing these results in incomplete relationship resolution and rubric
failure.
Correct Answer: B
Q4. In a library management system scenario, which data requirement would be
classified as a derived attribute rather than a base attribute?
A. Book ISBN number
,B. Member's date of birth
C. Number of books currently checked out by a member [CORRECT]
D. Book publication date
Rationale: The count of checked-out books is calculated from loan records (derived),
while ISBN, DOB, and publication date are directly stored base attributes.
Correct Answer: C
Q5. When documenting assumptions for a C170 PA project, which statement represents
a VALID assumption?
A. "The database will never need backup procedures."
B. "All customer phone numbers follow the North American format." [CORRECT]
C. "The system will prevent all possible data entry errors."
D. "No future enhancements will be required after deployment."
Rationale: Valid assumptions are realistic, verifiable, and scope-defining. Phone format
assumptions are common and testable, while others are unrealistic or scope-creeping.
Correct Answer: B
Q6. A scenario describes an e-commerce system where "orders contain products." What
critical entity is MISSING from this incomplete description that would prevent proper
ERD development?
A. Order Status
, B. Order Line Item (junction/associative entity) [CORRECT]
C. Product Category
D. Customer Review
Rationale: The M:N relationship between Orders and Products requires an associative
entity (Order Line Item) to properly model quantity, price at time of order, etc.
Correct Answer: B
Q7. Which stakeholder concern would MOST likely drive the need for a "Supplier" entity
in a retail inventory database?
A. Marketing wants to send promotional emails
B. Purchasing needs to track which supplier provided each product [CORRECT]
C. HR needs to manage employee benefits
D. Finance wants to calculate sales tax
Rationale: Supplier entity directly addresses purchasing department's need to trace
product sourcing, manage reorder points, and evaluate supplier performance.
Correct Answer: B
Q8. During scenario analysis for a rental property system, which business rule would
require a CHECK constraint at the database level?
A. Each property must have a unique address
B. Rental rate must be greater than zero [CORRECT]
