Look Up Tables

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

Questions by vinayrao

Showing Answers 1 - 3 of 3 Answers

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions