title: How do I represent SQL Server ntuples in first normal form in a schema
body: <p>I am working on building Test Case Manager database where each test case can have a set of test steps. </p>
  
  <p>I created a Test Case table, which has as one of its fields a foreign key to the Test Step Groups table. The Test Step Groups table represents  sets of test steps. There is a separate Test Step table to contain rows of test step data.</p>
  
  <p>Each Test Case may contain any number of test steps. I want to be able to re-use sets of test steps, because sometimes test cases re-use sets of steps and then add on other steps. It's not a hierarchical structure, of course, more of an n-tuple structure.</p>
  
  <p>So how do I define in the schema a representation of a Test Case with any number of test steps? </p>