Re: MySQL and 3NF

2002-01-30 Thread admin
Hi. I would type museum: department or likewise in name field if its not so many it would work nicely. But thats just me:) /PM\ David S. Jackson wrote: Hi, I came across a relationship between entities that I hadn't counted on, and I'm trying to adjust my database tables to handle

RE: MySQL and 3NF

2002-01-30 Thread Johnson, Gregert
Create two association tables: Contributor ++--+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-++ | Contributor_ID | tinyint(3) | |