I have one table that I want to separate them into two to normalize the data. I want a opinion of the best way of doing it.
My table has lots of columns and one of them I was storing Varchar values separated by comma, for instance: John, Mary, Joseph and so on. Now I created a new table called names. This table has two columns: name_id (primary key), name (the same varchar).
My doubt is because I ended up with the same thing, but now, instead of saving the names, I'm saving the primary keys. For instance: 1,3,5.
Is there a better way of saving this data to better organize those tables?