Re: Normalized or not, that's the question ...

In article <329C53B2.6B8D_at_ezv.admin.ch>, Rene.Wachs_at_ezv.admin.ch says...
>We have a 'hot' (and loud ...) discussion here about the degree of
>normalization of a table. We're working on a three lingual application
>(german, french and italian) and have to store text for each language.
>An user can only select (no updates, inserts or deletes allowed) and
>seee then the text in its own language.
>
>Some developers said the table must look like this :
>
> nr number primar key,
> text_g varchar2(30),
> text_f varchar2(30),
> text_e varchar2(30)
>
>Ohters said that's wrong : we have to create a table for each language :
>
> Table German
> ------------
>
> nr number primary key,
> text varchar2(30)
>
>and the same for french and italian.

The table should look like

   create table messages (

     nr    number      , -- message id
     lgge  number      , -- language id (1=german, 2=french, 3=italian ..)
     text  varchar2(30),
     primary key ( nr , lgge ) ) 

hth

-- 
    _/_/_/   _/_/_/ _/    _/  // Reinhard Kuhn             /  It can be      
   _/    _/ _/     _/  _/    //         (kuhn_at_cas-ps.com) /  done quickly,   
  _/_/_/   _/_/_/ _/_/      // CAS GmbH                  /  cheaply or well  
 _/  _/   _/     _/  _/    // Lemberger Strasse 14      /   - pick any two!  
_/   _/  _/_/_/ _/    _/  // 66955 Pirmasens, Germany  /