There are different forms of normalization you need to read about, but in this example the right path to solve this anomaly most likely would be to create three tables i.e. Student, Course, and StudentCourse which will allow you to store Student and Course data without duplicates and anomalies, as well as assign many courses to many students.