Discussion: Normalization
Afficher un message
Vieux 18/09/2007, 20h21   #1
Amit Jain
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut 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

  Réponse avec citation
 
Page generated in 0,04924 seconds with 9 queries