What are lookup tables? Why they are used? Where they are used?

ponnarasuk

 Profile Answers by ponnarasuk Questions by ponnarasuk

• Jul 9th, 2008

When a foreign key exists in a table, the foreign key’s table is sometimes referred to as a lookup table. The DEPARTMENT table in our example is a lookup table for the EMPLOYEE table. The value of an employee’s department can be looked up in the DEPARTMENT table

Answer Question  Select Best Answer