Mapping Requirements to Test Cases

When to use this skill

• •When the user provides a "Requirement document" and "Existing test cases" (Excel or JIRA Ticket ID).
• •When asked to identify "Missing test cases", "Duplicate test cases", and "Incomplete coverage".
• •When a requirement-to-test-case mapping/gap analysis report is needed.

Workflow

1. •Requirement Extraction:
   • •Read the requirement document (PDF, Text, Word, or Markdown).
   • •Parse and identify unique Requirements (e.g., REQ-001, FR-01, or bullet points).
   • •Store Requirement IDs and Descriptions in a list.
2. •Test Case Extraction:
   • •Excel/CSV: Use pandas to load the file. Identify columns for "Test Case ID", "Test Description", and "Requirement Mapping/Requirement ID".
   • •JIRA: If a JIRA Ticket ID is provided, use available JIRA tools (or ask user for details) to fetch the "Test Issues" linked to the requirement.
3. •Cross-Mapping & Gap Analysis:
   • •Covered: A requirement is covered if it appears in the "Requirement Mapping" column of at least one test case.
   • •Missing: A requirement is missing if no test case maps to it.
   • •Duplicates: Flag requirements that have multiple test cases covering the exact same validation logic.
   • •Incomplete: Flag requirements that have a test case but lack specific edge cases (e.g., negative testing).
4. •Reporting:
   • •Generate the summary report in the table format requested.

Instructions

1. Parsing Requirements

If the document is unstructured, use regex or keyword search for tokens like REQ-, MUST, SHOULD. Example:

• •FR-login: User must be able to login with valid credentials.

2. Reading Excel Test Cases

import pandas as pd
# Load and peek at headers
df = pd.read_excel('path/to/test_cases.xlsx')
print(df.columns)
# Identify the mapping column (e.g., 'Requirement ID', 'Linked Req')
mapping_col = 'Requirement ID' 

3. Gap Analysis Logic

• •Missing: set(requirements) - set(mapped_requirements)
• •Duplicate: Count occurrences of (Requirement ID, Test Case Logic) pairs.
• •Coverage Summary: Calculate % of requirements covered.

Output Format

Additional Findings

• •Duplicate Test Cases:
  • •TC-01 and TC-05 both cover "User login" with identical steps.
• •Incomplete Coverage:
  • •REQ-002 (Logout) only has a "Happy Path" test case; missing "Session Timeout" scenario.

Resources

• •Example Report