What is the best way to normalize the tables in SQL..:$

Hey Hi everyone..

Well i have all the tables ready for my data base.. but got to normalize them...:(

Is there any best possible way to get the tables normalized..? If so.. plz do let me know guys..:)

regards

kiran

You might need to give a little more info on what your present table schema looks like.

Also, asking this in the database forums might help get more precise answers.

Hey Thanx and sorry buddy..

K.. this is how my table looks..

Empid, Fname, Lname, Country, Visatype, Documentstype, File

here,, country , visatype, documents tyoe, file are all multivalued... so i think theres a need of creating seperate tables for each one with empid as the pk...

so.. got any solns .. plz do reply me

thanks in advance