CREATE TABLE Employee (

employee_id INT AUTO_INCREMENT.

first name VARCHAR(50), last_name VARCHAR(50), email VARCHAR(100), hire date DATE, birth date DATETIME, salary DECIMAL(10, 2),

department_id TINYINT, is active BOOLEAN.

profile picture BLOB, employee_code CHAR(10).

rating FLOAT, created at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (employee_id) );

CREATE TABLE Department (

department_id TINYINT AUTO_INCREMENT, department_name VARCHAR(50), location VARCHAR(50), PRIMARY KEY (department_id) ); output