Question on Multiplicity

Imagine you were knocking up a simple table of animals and their
predominant colors. Something of the order:

----------------------
animal | color
----------------------
swan | white
lion | yellow
oranguatan | orange
----------------------

Consider also that some animals that have multicolored fur. For
instance a zebra is black and white. Keeping the table nice and
normalized yields:

----------------------
animal | color
----------------------
swan | white
lion | yellow
oranguatan | orange
zebra | black
zebra | white
----------------------

Now you find out that while most swans are white, there are some swans,
although a minority, that are completely black. You can't encode that
into table without introducing a new column to identify an individual
instance of an animal, or you will not be able to distinguish between
an entry which is multi-colored (the zebras) and an entry which is
either completely one color or the other (the swans).

Now my question is am I missing anything - is there any method of
making this distinction without having to introduce a new reference
column to resolve the ambiguity?

Many thanks, Jason.

.

Relevant Pages

  • Re: OT Fishing ban
    ... animals but fox hunting has been banned, also what about all the swans who ... The fox causes suffering to other animals. ... You nuts think free time means time to make something suffer. ...
    (uk.rec.caravanning)
  • Re: Swans
    ... and giving way to swans, or rabbits, or foxes, or any other animals, then ... well be encroaching on their territory, and remember, people territory ... that I'm somehow angry at the swans, or that I somehow expect that they ...
    (uk.rec.cycling)
  • Re: Swans
    ... and giving way to swans, or rabbits, or foxes, or any other animals, then ... If you feel threatened by those animals, ... well be encroaching on their territory, and remember, people territory and ... that I'm somehow angry at the swans, or that I somehow expect that they ...
    (uk.rec.cycling)
  • Re: Swans
    ... Now that bike riders - typically junior riders or commuters - ... and giving way to swans, or rabbits, or foxes, or any other animals, then ... If you feel threatened by those animals, ... well be encroaching on their territory, and remember, people territory and ...
    (uk.rec.cycling)
  • Re: Mergefields, IF statements and section breaks
    ... rather than keeping their original formatting. ... So could I still use conditional statements with INCLUDETEXT? ... > If my database record is 'zebra', I only want my zebra document to ... a fact sheet about zoo animals). ...
    (microsoft.public.word.mailmerge.fields)