Re: One Table or Two ?

Hi

For me I will do the following:

Table

Id, acrnonym, explanation, language

also with that approach you don't limit your self with 2 language.

Regards

Eric

"Hunter" <dave_h4_at_yahoo.com> wrote in message news:27ad91d2.0211270444.25678abf_at_posting.google.com...
> Hi All -
>
> I'm creating an online searchable acronyms dictionary. It wil be
> populated with:
> Acronym | What it stands for | Explanation of Acronym
>
> The user will choose in which language to recieve results (English or
> French). I'm wondering if I should build it using one unique table, or
> two tables:
>
> id acronym_eng acronyms_fre explanation_eng explanation_fre
>
> OR
>
> Table 1 = Acronyms_english
> id acronyms_eng explanation_eng french_id
>
> Table 2 = Acronyms_french
> id acronyms_fre explanation_fre english_id
>
>
> TIA, dave
Received on Wed Nov 27 2002 - 17:38:47 CET