N1NF to 1NF table conversion
I am migrating some data from EXCEL to MySQL, which include tables of the following form:
Person | Favorite Colors
-------- --------------------
Bob | blue, red
Jane | green, yellow, red
Which is a design that does not comply with 1NF. A more semantically correct design would be:
Person | Favorite Color
-------- --------------------
Bob | blue
Bob | red
Jane | green,
Jane | yellow
Jane | red
The real file is more complicated, with over 900 entries, making the conversion tedious. What can you suggest as a scripted solution to my problem?
Edited 1 time(s). Last edit at 07/06/2009 06:06AM by Altaz Belim.
Subject
Views
Written By
Posted
N1NF to 1NF table conversion
5705
July 06, 2009 03:51AM
2962
July 06, 2009 08:44AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.