Matching Students to Test Records

Requirements Clarification & Assessment

• Objective: Identify which student from the roster took each test using two tables: Students and Tests.
• Data Characteristics:
  • Students Table: Contains student ID, first name, last name, and date of birth.
  • Tests Table: Contains first name, last name, date of birth, test score, and test date.
• Challenges:
  • Lack of direct student ID linkage between tables.
  • Potential inaccuracies in names and dates due to manual entry errors.
• Assumptions:
  • Human assistance is available for verification.
  • Thousands of rows are involved, necessitating efficient matching methods.
  • Exact matches across all fields are rare, necessitating alternative matching strategies.