php - how can id assign foreign key mysqli

Question

I have created at 2 tables. These tables are Department, employee.

Now i want to assign foreign key in department table and join with employee table.

have any idea??

SELECT id,department FROM department; 
SELECT * FROM `employee'

Answer 1

create employee table field are- id(primary key),name,dept_id
department table fields are-dept_id(primary key),name

after select the dept_id.give index.

than select the department table and dept_id.than click save button.