Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2001
    Posts
    3

    Unanswered: Database Design and Form Input

    I would appreciate some help with the following –

    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.
    Any ideas?
    Thank you.
    Simon.

  2. #2
    Join Date
    May 2002
    Location
    Vancouver Canada
    Posts
    26
    Yeah, sounds like there could be a number of different forms needed, not unusual for something like this.

    Your table relations seemed okay, but then I got lost. Have you figured the rest out yet?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •