Create SoftUni Database

CREATE TABLE towns (
`id` INT AUTO_INCREMENT, `name` VARCHAR(55) NOT NULL, PRIMARY KEY (id));

CREATE TABLE addresses (
id INT AUTO_INCREMENT, address_text VARCHAR(55) NOT NULL, town_id INT, PRIMARY KEY (id));

ALTER TABLE `addresses`
ADD CONSTRAINT fk_addresses_towns FOREIGN KEY (`town_id`) REFERENCES `towns`(`id`);

CREATE TABLE departments (
`id` INT AUTO_INCREMENT, `name` VARCHAR(55) NOT NULL, PRIMARY KEY (id));

CREATE TABLE employees (
id INT AUTO_INCREMENT, first_name VARCHAR(30) NOT NULL, middle_name VARCHAR(30),
last_name VARCHAR(30) NOT NULL, job_title VARCHAR(45) NOT NULL, department_id INT,
hire_date DATE, salary DOUBLE, address_id INT, PRIMARY KEY (id));

ALTER TABLE `employees`
ADD CONSTRAINT fk_employees_departments FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
ADD CONSTRAINT fk_employees_addresses FOREIGN KEY (`address_id`) REFERENCES `addresses` (`id`);