Page 1 of 1

Trouble normalizing

Posted: Wed Feb 02, 2011 10:25 am
by peachiness
So I am trying to move all the authors to their own table and keywords to their own table

from

Image

to

Image

the problem is how do I keep the associations once I move everything from the first table?

I don't want to manually create an association table o.O

Re: Trouble normalizing

Posted: Wed Feb 02, 2011 11:50 am
by VladSun
Create a third, many-to-many table.

Re: Trouble normalizing

Posted: Wed Feb 09, 2011 1:38 pm
by peachiness
VladSun wrote:Create a third, many-to-many table.
Right, I am trying to create that table..but how do i go about doing that without having to manually enter all the associations?

Re: Trouble normalizing

Posted: Wed Feb 09, 2011 1:43 pm
by VladSun
Create an SQL script to do it for you :) Not so difficult.