Understanding Lookup Tables in Excel and SQL

Lookup tables are a critical feature of good database design: lookup tables store information that other tables can refer to (or look up). These other tables are typically transaction tables that store things that happen, while the data stored in loo...