Lookup tables are used to...

• A. They increase data redundancy
• B. Provide standard values for fields
• C. They complicate data entry
• D. They have no effect on data integrity

Answer: (B)

Lookup tables store a controlled set of values that are valid for certain fields. By referencing these predefined codes or names from the main records, you ensure consistency across the database and applications. This is why they provide standard values for fields: entries must match one of the recognized options, reducing typos, variations, and inconsistent reporting. Maintenance is easier because changes or additions happen in one place and then apply everywhere the value is used. They improve data integrity by enforcing valid, standardized inputs and typically simplify data entry rather than making it more difficult.