Re: Normalization Question

From: Dawn M. Wolthuis <dwolt_at_tincat-group.comREMOVE>
Date: Fri, 21 Jan 2005 10:27:57 -0600
Message-ID: <csraiq$a02$1_at_news.netins.net>

"Leandro Guimar�es Faria Corsetti Dutra" <leandro_at_dutra.fastmail.fm> wrote in message news:pan.2005.01.21.06.55.35.625887_at_dutra.fastmail.fm...
> Em Fri, 21 Jan 2005 00:19:31 +0100, BG escreveu:
>
>> To abide by the rules of normalization, should the phone & date
>> fields be placed into their own tables?
>
> No, but that may be good design anyway as you may want to save
> more than one telephone of each type, for example.

It is such a shame that you have to guess at future cardinality right up front when designing a relational structure, eh? Wouldn't it be great if we could design at a level where a change in multiplicity, like a change in size, type, or constraints, could be handled without a changing the logical model of the data? smiles. --dawn

> --
> Leandro Guimar�es Faria Corcete Dutra <leandro_at_dutra.fastmail.fm>
> Maring�, PR, BRASIL +55 (44) 3025 6253
> http://br.geocities.com./lgcdutra/ +55 (44) 8803 1729
> Soli Deo Gloria! +55 (11) 9406 7191
>
Received on Fri Jan 21 2005 - 17:27:57 CET

This message: [ Message body ]
Next message: Hugo Kornelis: "Re: Displaying items in a table according to the earliest date found in a column"
Previous message: nathan.cutmore_at_burohappold.com: "Displaying items in a table according to the earliest date found in a column"
Maybe in reply to: BG: "Normalization Question"
In reply to Leandro Guimarães Faria Corsetti Dutra: "Re: Normalization Question"
Next in thread: Neo: "Re: Normalization Question"
Reply: pc: "Re: Normalization Question"
Reply: Leandro Guimarães Faria Corsetti Dutra: "Re: Normalization Question"
Reply: Marshall Lucas: "Re: Normalization Question"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message