MySQL and 3NF

2002-01-30 Thread David S. Jackson
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 this new relationship. I need some help with visualizing and implementing this relationship into the database design. The database is for an inventory of

Re: [ale] MySQL and 3NF

2002-01-30 Thread Tommie M. Jones
From what I understand. Move the volunteer_id from the contributor table. put the contributor_id inside the volunteer table. This way you can have a 1-to-many relationship between the two. --- Get inside Atlanta's Tech Scene - http://www.atlantageek.com 'Business

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
| ++--+--+-+-++ -- Greg Johnson -Original Message- From: David S. Jackson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 11:15 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: MySQL and 3NF Hi, I came