The FOREIGN KEY constraint is used to enforce a link between the data in two tables. A foreign key in one table points to a primary key in another table, maintaining referential integrity.
-- 16. Write a MySQL query to create a table employees including columns employee_id, first_name, last_name, email, phone_number hire_date, job_id, salary, commission, manager_id and department_id and ...