title: Saving an array of strings to an SQL column
body: <p>I want to create a "sessions" table in an SQL database for a school project. Each session should have:</p>
  
  <ul>
  <li>Session ID</li>
  <li>Lecturer name</li>
  <li>Time and date</li>
  <li>Module name</li>
  <li>Course name</li>
  <li>List of student IDs</li>
  <li>List of student statuses(Present, absent, late)</li>
  </ul>
  
  <p>How can I represent such a thing ???</p>
  
  <p>Is it better to create ONE table to represent all sessions, where each session would be one row, and have an array of strings in each column that represents the names, IDs, and status of students??</p>
  
  <p>OR</p>
  
  <p>Create a new table for each new session ??</p>
  
  <p>What is better, and please explain how to do it briefly.</p>
  
  <p>Bear in mind, that I would need to insert/delete/update/view each table from a C# windows application, and the maximum expected number of sessions is just 100.</p>
  
  <p>Also, I am using SQL Server 2012 with a C# windows application developed with Visual Studio 2012</p>
  
  <p>Thanks</p>