Re: One Table or Two ?

From: Eric Manseau <emanseau_at_cae.com>
Date: Wed, 4 Dec 2002 13:13:32 -0500
Message-ID: <aslggl$1b4$1_at_dns3.cae.ca>


I hunter,

If you want the result for each language, you can build view :

create view english_acronym is
select Id,

          acronym,
          explanation

from acronym_table
where language = 'English';

Eric
"Hunter" <dave_h4_at_yahoo.com> wrote in message news:27ad91d2.0211281011.25a5a590_at_posting.google.com...
> Thanks Eric. I'm not too sure I understand.
>
> If i do:
> > Id, acrnonym, explanation, language
>
> and someone only want to see reults in English then they won't be able to
 right ?
>
> Also - the acronym will change based on the language.
>
> Maybe I'm not quite understanding your theory.
>
> thanks, dave
>
>
>
> "Eric Manseau" <emanseau_at_cae.com> wrote in message
 news:<as2sbg$nj4$1_at_dns3.cae.ca>...
> > 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 Dec 04 2002 - 19:13:32 CET

Original text of this message