Correspondance of attributes in tables:

Potential      |      Field Referred to
Foreign Keys
----------------------------------------
comm.kemail    |	faculty.kemail
comm.comm      | 	committee.abbr
faculty.rank   |	rank.abbr
faculty.status |	status.abbr
faculty.campus |	campus.abbr
faculty.college|	college.abbr
faculty.dept   |	dept.abbr
dept.college   |	college.abbr