title: good practice in MySQL DB structure
body: <p>I'm working on a system to manage students attendance in class. I created two tables: student (student_id,name,mail..) and course (course_id, name, lecturer...). now my question is how should i keep record of which students taking which courses?</p>
  
  <p>should i create another table for each course with this structure:
  course_id,lecturer,student_1,students_2,student_3...</p>
  
  <p>or maybe there is a better solution for creating this relation?
  tx</p>
  
  <p><strong>UPDATE:</strong> i should have mentioned that student can take several courses</p>