Здравейте, имам проблем с тази задача:

15. Basic Insert

© SoftUni – about.softuni.bg. Copyrighted document. Unauthorized copy, reproduction or use is not permitted.
Follow us: Page 2 of 5
Now create bigger database called soft_uni. You will use database in the future tasks. It should hold information
about
• towns (id, name)
• addresses (id, address_text, town_id)
• departments (id, name)
• employees (id, first_name, middle_name, last_name, job_title, department_id, hire_date, salary, address_id)
Id columns are auto incremented starting from 1 and increased by 1 (1, 2, 3, 4…). Make sure you use appropriate
data types for each column. Add primary and foreign keys as constraints for each table. Use only SQL queries.
Consider which fields are always required and which are optional.
Do not submit creation of database only the insert statements.

Use the SoftUni database and insert some data using SQL queries.

name job_title department hire_date salary
Ivan Ivanov Ivanov .NET Developer Software Development 01/02/2013 3500.00
Petar Petrov Petrov Senior Engineer Engineering 02/03/2004 4000.00
Maria Petrova
Ivanova Intern Quality Assurance 28/08/2016 525.25
Georgi Terziev Ivanov CEO Sales 09/12/2007 3000.00
Peter Pan Pan Intern Marketing 28/08/2016 599.88
 towns: Sofia, Plovdiv, Varna, Burgas
 departments: Engineering, Sales, Marketing, Software Development, Quality Assurance
 employees:

Submit your INSERT queries in Judge as Run skeleton, run queries & check DB.

Стигнал съм дотук - https://pastebin.com/b3wR8xWD

и на зявката

INSERT INTO `employees` (`id`, `first_name`, `middle_name`,
`last_name`, `job_title`, `department_id`, `hire_date`, `salary`)
VALUES
(1, 'Ivan', 'Ivanov', 'Ivanov', '.NET Developer', 4, '2013-02-01', 3500.00),
(2, 'Petar', 'Petrov', 'Petrov', 'Senior Engineer', 1, '2004-03-02', 4000.00),
(3, 'Maria', 'Petrova', 'Ivanova', 'Intern', 5, '2016-08-28', 525.25),
(4, 'Georgi', 'Terziev', 'Ivanov', 'CEO', 2, '2007-12-09', 3000.00),
(5, 'Peter', 'Pan', 'Pan', 'Intern', 3, '2016-08-28', 599.88);

Workbench ми дава следния отговор:

Error Code: 1452. Cannot add or update a child row: a foreign key constraint fails (`soft_uni`.`employees`, CONSTRAINT `fk_employees_departments` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`))

Какво трябва да коригирам, за да се изпълни успешно заявката и оттам да мога да реша следващите задачи, които са свързани с тази и без това въвеждане не мога да продължа?

Благодаря предварително.