Normalization At present i have one table with name Destination which contain data
in English:->
Destination:->
-------------------------------------------------------------------------------
DestID Name Description
-------------------------------------------------------------------------------
where
DestId field is Primary key store Destination ID.
Name field contain name of destination example any city name.
Description field store description of city (like history).
Now I want to store Name and Description in other language so suggest/
idea how my table look.
Destination:->
----------------------------------------------------------------------------------------------------------------------------
DestID Name Description GermanName
GermanDescription
-----------------------------------------------------------------------------------------------------------------------------
or
DestinationMaster:->This table store content in English language
--------------------------------------------------------------------
DestID Name Description
--------------------------------------------------------------------
DestinationGerman:->This table store content in Geraman language
-------------------------------------------------------------------
DestID Name Description
-------------------------------------------------------------------
DestinationDutch:->This table store content in Dutch language
------------------------------------------------------------------
DestID Name Description
------------------------------------------------------------------
Thanks,
Amit Jain |