title: I have a single table format used by 2 independent groups of people, do I make 2 tables or 1?
body: <p>I have 2 set of data about products, both have the same columns but each I used by a different independent group of users.  </p>
  
  <p>I'm not sure if I should store the 2 categories data together or separately. </p>
  
  <p>If I put it in 1 table it'd look like</p>
  
  <pre><code>dbo.Products
  ID | ..... | Catagory
  </code></pre>
  
  <p>If I do 2 tables.</p>
  
  <pre><code>Cat1.Products
  ID | .....
  Cat2.Prodcuts
  ID | .....
  </code></pre>
  
  <p>Edit: The categories both use the same columns.</p>