CREATE TABLE departments (
    dept_id INT PRIMARY KEY,
    name VARCHAR(100) NOT NULL
);

CREATE TABLE employees (
    emp_id INT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    dept_id INT,
    salary DECIMAL(10,2),
    FOREIGN KEY (dept_id) REFERENCES departments(dept_id)
);


INSERT INTO departments (dept_id, name) VALUES
(1, 'HR'),
(2, 'IT'),
(3, 'Sales');

INSERT INTO employees (emp_id, name, dept_id, salary) VALUES
(1, 'Alice', 1, 3500.00),
(2, 'Bob',   2, 4200.00),
(3, 'Carol', 2, 4800.00),
(4, 'Dave',  3, 3900.00),
(5, 'Eve',   3, 4100.00);