First page Back Continue Last page Image

Identify Bogus Lookup Tables

If Single Key Column appears in another table as a key – Not a Lookup
Any non-key values goes beyond the lookup task – Not a Lookup
Used in SQL command to insert rows into tables – Not a Lookup

DeptAcro	DeptName	DeptBldg
IT	Information Technology	IB
EET	Electronics Technology	IB
CS	Computer Science	IB

DeptAcro	DeptName	DeptChairID
IT	Information Technology	456
EET	Electronics Technology	222
CS	Computer Science	486