refernces column for table

Question

hi

 

anyone please help me

 

how to create a reference column for a table

 

i will send table structure please send me

 

physician:

employeeid – this is a unique ID of a physician(primary key it should be auto increment)

name – this is the name of a physician

position – this is the designation of a physician

ssn – this is a security number of a physician

department:

departmentid – this is a unique ID for a department(primary key it should be auto increment)

name – this is the name of a department

head – this is the ID of the physician who is the head of a department, referencing to the column employeeid of the table physician