SQA and Requirements Testing | Dataford Interview Questions

Describe how you would use a traceability matrix and boundary value analysis when testing an SRS for an i2c project.

Represent the traceability matrix with requirement-to-test links and record each test's boundary classification. Write a SQL query that audits every requirement for linked test coverage and both lower and upper boundary coverage.

Output

One row per SRS requirement, including requirements without linked tests.
Columns: requirement_id, requirement_key, linked_test_count, lower_boundary_count, upper_boundary_count, traceability_status, and boundary_status.
Order by requirement_id ascending.

Schema

srs_requirements

Column	Type	Description
requirement_idPK	INT	Unique SRS requirement identifier
requirement_key	VARCHAR(20)	Human-readable requirement reference
requirement_text	TEXT	Requirement statement

test_cases

Column	Type	Description
test_case_idPK	INT	Unique test case identifier
test_name	VARCHAR(100)	Test case name
boundary_type	VARCHAR(20)	Boundary classification, such as lower, upper, or nominal
test_status	VARCHAR(20)	Execution status of the test case

requirement_test_links

Column	Type	Description
requirement_id	INT	Referenced SRS requirement
test_case_id	INT	Referenced test case

Your question is SQA and Requirements Testing. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem