title: Records for Sales Person
body: <p>I am designing this database and c# app, that a record gets saved to database. now say we have three Sales Person and each should be assigned a record in strict rotation so they get to work on equal amount of records.</p>
  
  <p>What I have done so far was to create one table called <code>Records</code> and one <code>SalesPerson</code>, the Records would have salesperson <code>id</code> as foreign key and another column that would say which agent it is assigned to and will increment this column.</p>
  
  <p>Do you think this is a good design, if not can you give any ideas?</p>