I have one table : country (
name , population,capital,capital_stat1 , area , second_name , bla , bla , bla ... )
can this table become 2 tables 1-1 like :
country (
name , population , area , second_name , .... bla bla )
capitals (
name , capital_stat1 , other_referring_capital )
If this is right , is possible the 2 tables become just one again or is one of these ways wrong ??? Does the effieciency counts more in the 1st or 2nd???
Thanx
