Let’s say that we have a table named SCHOOLS that contains general details about the school.
We want to allow each school to enter one or more courses, so we have a table named COURSES. (Each school can have one or many courses and each course can have one or many schools). Note: Most courses will only relate to one school but if the school has partner/branch schools they may share the same courses.
Each of the courses has up to 20 different entry levels (Beginner, Elementary, Intermediate, Advanced, etc.), so we have a table named LEVELS. (Each course can have one or many levels and each level can have one or many courses).
Each of the entry levels may have 10 hour, 15 hour, 20 hour, 25 hour per week time options so we have a table named TIMES. (Each level can have one or many times and each time can have one or many levels).
Each time option may have different start dates so we have a table named DATES. (Each time can have one or many dates and each date can have one or many times). Note: There may also be different dates for different levels so we need some relation there as well ??????????.
Each level, time and date may also have different pricing so we have a PRICE table. (this is where it starts to get real complicated ?????????????).
I welcome advice on any of the above but what I really can’t picture is the best html form layout to gather all of the details. To me it seems that the user (school) would have to complete a great number of fields spread out of 4 or 5 pages for EACH course they want to enter. Some schools may have 50 courses.