I have to write a software to manage a music school. I started working on this when i suddenly realised that a student can take 2 lessons (e.g guitar and theory together) and i must have a way to add it to the students record. Not only that but the 2 subjects may be the responsibility of 2 different teachers which is something i have to include in the students Record....

My major problem is how to store the two subjects for the same field (lesson) in a file but be able to distinguish them when loading...


Example
Name: George
Surname: Smith
Address: West Street
Lessons: Guitar, Theory
Teachers: Mr. John, Mrs. Sally
thank you

Is it database design problem or VB.NET one?
Please mention your db design to help you out how to solve it