data.sql

-- ============================================
-- HR Management System - Sample Data
-- ============================================

INSERT INTO employees
(employee_id, first_name, last_name, email, hire_date, job_id, salary, manager_id, department_id)
VALUES
(100, 'John', 'Smith', 'john.smith@company.com', '2020-01-15', 'IT_MGR', 120000, NULL, 10),
(101, 'Alice', 'Johnson', 'alice.johnson@company.com', '2021-03-20', 'IT_PROG', 85000, 100, 10),
(102, 'Bob', 'Wilson', 'bob.wilson@company.com', '2021-06-10', 'IT_PROG', 80000, 100, 10),
(103, 'Carol', 'Davis', 'carol.davis@company.com', '2019-09-05', 'HR_REP', 60000, NULL, 20),
(104, 'David', 'Brown', 'david.brown@company.com', '2022-02-14', 'FIN_ANALYST', 70000, NULL, 30),
(105, 'Emma', 'Taylor', 'emma.taylor@company.com', '2020-11-30', 'MKT_MGR', 95000, NULL, 40),
(106, 'Frank', 'Green', 'frank.green@company.com', '2021-08-25', 'SALES_REP', 65000, 105, 40),
(107, 'Grace', 'White', 'grace.white@company.com', '2019-05-12', 'IT_PROG', 90000, 100, 10),
(108, 'Henry', 'Clark', 'henry.clark@company.com', '2022-07-18', 'HR_REP', 55000, 103, 20);

INSERT INTO departments
(department_id, department_name, location)
VALUES
(10, 'IT', 'SanFrancisco'),
(20, 'HR', 'NewYork'),
(30, 'Finance', 'Chicago'),
(40, 'Marketing', 'LosAngeles'),
(50, 'Operations', 'Seattle');

INSERT INTO jobs
(job_id, job_title, min_salary, max_salary)
VALUES
('IT_PROG', 'Software Developer', 60000, 120000),
('IT_MGR', 'IT Manager', 90000, 150000),
('HR_REP', 'HR Representative', 45000, 75000),
('FIN_ANALYST', 'Financial Analyst', 50000, 85000),
('MKT_MGR', 'Marketing Manager', 70000, 110000),
('SALES_REP', 'Sales Representative', 40000, 80000);