CREATE TABLE employees (

id INT AUTO_INCREMENT PRIMARY KEY,

first_name VARCHAR(50) NOT NULL,

last_name VARCHAR(50) NOT NULL,

email VARCHAR(100) UNIQUE NOT NULL,

hire_date DATE NOT NULL

);

CREATE TABLE orders (

order_id INT AUTO_INCREMENT PRIMARY KEY,

customer_id INT,

order_date DATE NOT NULL,

total DECIMAL(10, 2) NOT NULL,

FOREIGN KEY (customer_id) REFERENCES customers(customer_id)

);

CREATE TABLE products (

product_id INT PRIMARY KEY,

product_name VARCHAR(100) NOT NULL,

category VARCHAR(50),

price DECIMAL(10, 2) NOT NULL,

stock INT DEFAULT 0

);

CREATE TABLE departments (

dept_id INT PRIMARY KEY,

dept_name VARCHAR(50) NOT NULL,

manager_id INT,

location VARCHAR(100),

FOREIGN KEY (manager_id) REFERENCES employees(id)

);