Re: Normalisation Problem
Date: Thu, 12 Apr 2001 02:45:34 GMT
Message-ID: <iF8B6.3859$FY5.268605_at_www.newsranger.com>
In article <Ux7z6.2993$jz.252464_at_www.newsranger.com>, Aloha Kakuikanu says...
>
>We are working on Ariphmetics database for American Mathematical Society and
>disagree upon the following problem in Schema Design. In my design I have a
>table:
>
>Table ADD_SUBTRACT_FACTS
>+----------+-----------+-----+------+
>| OperandA | OperandB | Sum | Diff |
+----------+-----------+------------+
>| 1 | 1 | 2 | 0 |
>| 5 | 3 | 8 | 2 |
>| ... | ... | ... | ... |
>+----------+-----------+-----+------+
>
>But other members of the team say that it's not normalized, and, therefore, have
>to be splitted into two:
>
I would suggest to decompose Operands in your design into:
OperandAinOnes
so that your first column become:
OperandAinTens
OperandAinHundreds
+----------------+----------------+--------------------+| OperandAinOnes | OperandAinTens | OperandAinHundreds |
+----------------+----------------+--------------------+ | 1 | 0 | 0 | | 5 | 0 | 0 |Received on Thu Apr 12 2001 - 04:45:34 CEST