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@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 - 10:27:57 CST