[thelist] Newbie - DB Design Help
Rob Smith
rob.smith at lexjet.com
Fri Jul 28 10:44:59 CDT 2006
<snip>Generally your entities will become tables. Where entities have a
M:N (Many:Many) relationship, you will need a "bridging" table. If you
do up your ER model first, your database schema (at least in 3rd normal
form) writes itself.</snip>
Yup. I agree that you disagree with me. You actually answered my next
post about the best way to rethink this approach:
Bridge_Dept_Prod
Deptarments ---------------------
---------------- bid int 4 PK Products
dept_id int 4 PK => dept_id int 4 FK -------------------
... product_id int 4 FK <= product_id int 4 PK
...
Yes, the bad and the good news here is that you get to effectively
micromanage the relationships in order to have a many-to-many
relationship.
Rob Smith
LexJet
rob.smith at lexjet.com
http://www.lexjet.com
(800)453-9538
(941)330-1210 Int'l
(941)330-1220 Fax
1680 Fruitville Road, 3rd Floor
Sarasota, FL 34236
More information about the thelist
mailing list