Lookup tables can be a force for good in a relational database. Whereas the ‚One True Lookup Table‘ remains a classic of bad database design, an auxiliary table that holds static data, and is used to lookup values, still has powerful magic. Joe Celko explains…