Need some DB help

[eluser]sandwormusmc[/eluser]
Cheesy ER diagram:

Code:

<1>=-=<2>

where 1 & 2 are tables with a M-M relationship.

translate to

Code:

<1>--=<3>=--<2>

So basically you'll have an intermediary table that holds the IDs of <1> and <2> as a unique entry for each row.

I.E. I track hosts and patches. Each host can have multiple patches installed on it, and each patch can be installed on multiple machines. A third table is necessary with a row specifying each host.id and patch.id to keep it in 3rd Normal Form (3NF).

Seems to work ...