Re: Newbie - restructuring to eliminate many-to-many

From: yyurvy <yyurvy_at_hotmail.net>
Date: Sun, 15 Apr 2001 21:01:58 -0500
Message-ID: <39A73B7A64EFCDAD.6E9BF3AAD00BBA45.6C410A2C8B84B6E0_at_lp.airnews.net>

You may want to check out the "Solid Embedded Engine" from Solid Information Technology. More info can be obtained at www.solidtech.com.

---

"in too deep" <fieury_at_hotmail.com> wrote in message news: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 Mon Apr 16 2001 - 04:01:58 CEST