Home Forums Database Design Relational Theory Is having a lookup table that is for multiple entities a common practice? RE: Is having a lookup table that is for multiple entities a common practice?

  • It's good to see such a solid concensus on this topic. I particularly like Joe's detailed description of some of the problems that the OTLT game can generate. 
    Although it seems common sense that a naval supplies database probably shouldn't have a table some of whose rows are about submarine launchable ICBMs while other rows are about sides of pork and yet others about footwear, it's very nice to have that backed up by a good detailed technical description of some of the problems it would entail.

    Tom