Normalizing a table with different structures
===

I have a normalized table(table a) and a non-normalized table(table b), like this:

http://www.dropmocks.com/iBkHOr

I want to insert a new row into the normalized table for each parent in the non-normalized table. So if there is a record in table B with two parents for a studentID, I want to insert two records into table A with each different parent name from table B, using the same student ID from table B

I've been struggling for with this for hours, any help would be appreciated on how to go about doing this.