went on contract for an insurance company to build their new platform. looking at the current system, found that they used lookup tables but they were putting the "description" column of the lookup into the main tables. I said that they should be putting a foreign key reference into these tables and the senior developers response... "then it would come up with a number rather than the description when I query the table"