Music School Managing Software
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
Dell XPS
Junior Poster in Training
85 posts since Sep 2007
Reputation Points: 10
Solved Threads: 0
Is it database design problem or VB.NET one?
Please mention your db design to help you out how to solve it
Ramy Mahrous
Postaholic
2,196 posts since Aug 2006
Reputation Points: 480
Solved Threads: 276
