Re: Normalisation Problem

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  |

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


>|    1     |     1     |  0  |

>|    5     |     3     |  2  |