Thread: Normalization
View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 10:27 AM
Amit Jain
 
Posts: n/a
Default 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

Reply With Quote