Home -> Usenet -> comp.databases.theory -> Newbie - restructuring to eliminate many-to-many

Newbie - restructuring to eliminate many-to-many

From: in too deep <fieury_at_hotmail.com>
Date: Fri, 02 Mar 2001 22:11:12 GMT
Message-ID: <4UUn6.6591$Ok4.923681_at_news1.rdc1.ct.home.com> 






I'm building a site that will hold about 1000 lesson plans for teachers. In
each lesson plan there is a list of "partners" (companies that will sponsor
job shadowing) from a posible list of 100 or more.



Here are my problems: Each lesson plan may belong to zero or more academic
subjects (but must be tailored to that subject) and each partner may belong
to zero or more lesson plans (depending on the subject).



e.g.:



science


    science lesson plan 1

        partner 1
        partner 2
    science lesson plan 2
        partner 2
        partner 3





math


    math lesson plan 1

        partner 1
        partner 3
    math lesson plan 2
        partner 3
        partner 4





The only way I can see to build the database is with many-to-many
relationships, but I fear that will make it much more difficult to code (in
.asp). Any thoughts would be highly appreciated. Don't hesitate to let me
know I'm an idot - you won't be the first.
Received on Fri Mar 02 2001 - 23:11:12 CET












Original text of this message