Re: Normalisation Problem

From: Mikito Harakiri <Mikito_member_at_newsranger.com>
Date: Fri, 06 Apr 2001 20:41:12 GMT
Message-ID: <IRpz6.3806$jz.321858@www.newsranger.com>

Where are you going to get the data? Will AMS members enter ones through GUI, or will you batchload?

I could provide you some data for a $1 a row...

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:
>
>Table SUM
>+----------------------------+
>| OperandA | OperandB | Sum |

 +----------------------------+


>|    1     |     1     |  2  |

>|    5     |     3     |  8  |

>| ... | ... | ... |
>+----------------------------+
>
>Table DIFFERENCE
>+----------------------------+
>| OperandA | OperandB | Diff|

 +----------------------------+


>|    1     |     1     |  0  |

>|    5     |     3     |  2  |

>| ... | ... | ... |
>+----------------------------+
>
>Also, we are not quite clear if we want to have identity columns for that
>table(s).
>
Received on Fri Apr 06 2001 - 15:41:12 CDT