Normalization Assistance!
937035May 13 2012 — edited May 14 2012I am a newbie to Oracle SQL Developer. I need help in finding out how to normalize data from excel spreadsheet and then to create an entity relationship diagram after that. I have seen how to import the excel file column's, but my question is do I need to create a new table for each item such as city, state etc? There is data already inputed, but needs to be normalized I.E. 1NF, 2NF etc. Any help would be appreciated!