Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

It is tempting to skip the column for male, but it is strongly advised to model a comprehensible table. In most cases, comprehensibility implies completeness (the mere fact that "male" is missing from a gender-table might cause suspicion).

Info

It is perhaps even more tempting to skip the [ ]-column for ELSE, but it is also strongly advised to model an ELSE-column whenever the values are not restricted by a value list.

If Applicant.Gender was in fact limited by a value list consisting of the values Male and Female and it is obvious the set will never expend, the ELSE-column would have been otioseredundant.

What to use?

The choice of method is often based on the preference of the business engineer. General recommendations are listed below:

...