title: Insert many rows to one table OR insert rows separately to many table?
body: <p>I have two DataBase Table (SQL CE). A <strong>Teacher</strong> table and a A <strong>Class</strong> table. The two tables have One-to-Many relationship where one teacher has many classes (i.e. <strong>Class</strong> has a foreign key <strong>teacher_id</strong>). Number of teachers (rows) is inserted (or generated) through C# code in run time, so as classes </p>
  
  <p>Which of the following is faster in INSERT and SELECT?</p>
  
  <ol>
  <li>Each time a new teacher is INSERTed, a new Class Table is created (e.g. Class_teacher001) to store whichever classes the teacher has. In this case, each Class Table doesn't have to be so large and foreign key is not needed because table name would identify itself. But there will be one Teacher table and many Class_xxx Tables</li><br/>
  
  <li>Only one Teacher table and one Class table. Each class row has a foreign key pointing at the Teacher table. Only one Class table, but it will get very long. I worry searching and reading wil be slow</li>
  </ol>