Sample Data

1. Departments — 15 records

INSERT INTO departments (department_id, department_name, location) VALUES
(1, 'Engineering', 'New York'),
(2, 'Sales', 'Chicago'),
(3, 'Human Resources', 'Boston'),
(4, 'Finance', 'New York'),
(5, 'Marketing', 'San Francisco'),
(6, 'IT', 'Seattle'),
(7, 'Operations', 'Dallas'),
(8, 'Customer Support', 'Austin'),
(9, 'Legal', 'Boston'),
(10, 'Procurement', 'Chicago'),
(11, 'Research', 'San Diego'),
(12, 'Product Management', 'New York'),
(13, 'Quality Assurance', 'Seattle'),
(14, 'Administration', 'Dallas'),
(15, 'Business Development', 'San Francisco');

2. Employees — 15 records

The department_id values correspond to the departments above.

The manager_id values point to another employee in this same table.

INSERT INTO employees 
(id, name, department_id, manager_id, job_title, salary, join_date, email) VALUES
(1, 'James Anderson', 1, NULL, 'Engineering Manager', 125000.00, '2026-03-15', 'james.anderson@example.com'),
(2, 'Sarah Williams', 1, 1, 'Senior Software Engineer', 110000.00, '2019-06-10', 'sarah.williams@example.com'),
(3, 'Michael Brown', 1, 1, 'Software Engineer', 95000.00, '2021-01-20', 'michael.brown@example.com'),
(4, 'Emily Davis', 2, NULL, 'Sales Manager', 115000.00, '2017-09-05', NULL),
(5, 'Daniel Wilson', 2, 4, 'Sales Executive', 78000.00, '2026-04-12', 'daniel.wilson@example.com'),
(6, 'Jessica Miller', 3, NULL, 'HR Manager', 105000.00, '2016-11-01', 'jessica.miller@example.com'),
(7, 'Robert Moore', 4, NULL, 'Finance Manager', 120000.00, '2026-07-18', 'robert.moore@example.com'),
(8, 'Linda Taylor', 5, NULL, 'Marketing Manager', 108000.00, '2019-02-25', 'linda.taylor@example.com'),
(9, 'William Thomas', 6, NULL, 'IT Manager', 118000.00, '2017-05-30', 'william.thomas@example.com'),
(10, 'Patricia Jackson', 7, NULL, 'Operations Manager', 112000.00, '2018-08-14', NULL),
(11, 'Christopher White', 8, NULL, 'Support Manager', 98000.00, '2020-01-06', 'christopher.white@example.com'),
(12, 'Barbara Harris', 9, NULL, 'Legal Counsel', 130000.00, '2016-10-21', 'barbara.harris@example.com'),
(13, 'Matthew Martin', 10, NULL, 'Procurement Manager', 102000.00, '2019-12-02', NULL),
(14, 'Susan Thompson', 11, NULL, 'Research Scientist', 115000.00, '2026-03-17', 'susan.thompson@example.com'),
(15, 'Joseph Garcia', 12, NULL, 'Product Manager', 125000.00, '2025-06-08', 'joseph.garcia@example.com');

3. Customers — 15 records

INSERT INTO customers
(customer_id, name, email, phone, signup_date, country) VALUES
(1, 'John Carter', 'john.carter@gmail.com', '555-1001', '2023-01-15', 'USA'),
(2, 'Emma Johnson', 'emma.johnson@gmail.com', '555-1002', '2023-02-20', 'USA'),
(3, 'Oliver Smith', 'oliver.smith@gmail.com', '555-1003', '2023-03-10', 'Canada'),
(4, 'Sophia Brown', 'sophia.brown@gmail.com', '555-1004', '2023-03-25', 'UK'),
(5, 'Liam Davis', 'liam.davis@gmail.com', '555-1005', '2023-04-12', 'USA'),
(6, 'Ava Wilson', 'ava.wilson@gmail.com', '555-1006', '2023-05-05', 'Australia'),
(7, 'Noah Miller', 'noah.miller@gmail.com', '555-1007', '2023-05-22', 'USA'),
(8, 'Isabella Moore', 'isabella.moore@gmail.com', '555-1008', '2023-06-14', 'Canada'),
(9, 'Ethan Taylor', 'ethan.taylor@gmail.com', '555-1009', '2023-07-01', 'USA'),
(10, 'Mia Anderson', 'mia.anderson@gmail.com', '555-1010', '2023-07-18', 'UK'),
(11, 'Lucas Thomas', 'lucas.thomas@gmail.com', '555-1011', '2023-08-03', 'USA'),
(12, 'Charlotte Jackson', 'charlotte.jackson@gmail.com', '555-1012', '2023-08-20', 'Germany'),
(13, 'Mason White', 'mason.white@gmail.com', '555-1013', '2023-09-11', 'USA'),
(14, 'Amelia Harris', 'amelia.harris@gmail.com', '555-1014', '2023-10-05', 'France'),
(15, 'James Martin', 'james.martin@gmail.com', '555-1015', '2023-11-12', 'USA');

4. Categories — 15 records

INSERT INTO categories
(category_id, category_name) VALUES
(1, 'Laptops'),
(2, 'Smartphones'),
(3, 'Tablets'),
(4, 'Monitors'),
(5, 'Keyboards'),
(6, 'Mice'),
(7, 'Headphones'),
(8, 'Cameras'),
(9, 'Printers'),
(10, 'Storage'),
(11, 'Networking'),
(12, 'Accessories'),
(13, 'Software'),
(14, 'Gaming'),
(15, 'Office Equipment');

5. Products — 15 records

Every category_id exists in the categories table.

INSERT INTO products
(product_id, product_name, category_id, price, vendor_id, stock_quantity) VALUES
(1, 'Dell Latitude 5540', 1, 899.99, 101, 25),
(2, 'iPhone 15', 2, 799.99, 102, 40),
(3, 'Samsung Galaxy Tab S9', 3, 649.99, 103, 30),
(4, 'LG UltraWide Monitor', 4, 449.99, 104, 18),
(5, 'Logitech MX Keys', 5, 99.99, 105, 50),
(6, 'Logitech MX Master 3', 6, 89.99, 105, 45),
(7, 'Sony WH-1000XM5', 7, 349.99, 106, 22),
(8, 'Canon EOS R10', 8, 979.99, 107, 12),
(9, 'HP LaserJet Pro', 9, 299.99, 108, 15),
(10, 'Samsung 1TB SSD', 10, 109.99, 109, 60),
(11, 'TP-Link WiFi 6 Router', 11, 129.99, 110, 35),
(12, 'USB-C Hub', 12, 49.99, 111, 75),
(13, 'Microsoft Office 365', 13, 99.99, 112, 100),
(14, 'PlayStation 5', 14, 499.99, 113, 10),
(15, 'Ergonomic Office Chair', 15, 249.99, 114, 20);

6. Orders — 15 records

Each customer_id exists in customers.

INSERT INTO orders
(order_id, customer_id, order_date, amount) VALUES
(1001, 1, '2024-01-05', 899.99),
(1002, 2, '2024-01-12', 799.99),
(1003, 3, '2024-01-20', 649.99),
(1004, 4, '2024-02-03', 449.99),
(1005, 5, '2024-02-15', 99.99),
(1006, 6, '2024-02-28', 89.99),
(1007, 7, '2024-03-05', 349.99),
(1008, 8, '2024-03-18', 979.99),
(1009, 9, '2024-04-02', 299.99),
(1010, 10, '2024-04-15', 109.99),
(1011, 11, '2024-05-01', 129.99),
(1012, 12, '2024-05-14', 49.99),
(1013, 13, '2024-06-03', 99.99),
(1014, 14, '2024-06-20', 499.99),
(1015, 15, '2024-07-05', 249.99);

7. Order Items — 15 records

Each order_id points to an existing order, and each product_id points to an existing product.

INSERT INTO order_items
(order_id, product_id, quantity, price) VALUES
(1001, 1, 1, 899.99),
(1002, 2, 1, 799.99),
(1003, 3, 1, 649.99),
(1004, 4, 1, 449.99),
(1005, 5, 1, 99.99),
(1006, 6, 1, 89.99),
(1007, 7, 1, 349.99),
(1008, 8, 1, 979.99),
(1009, 9, 1, 299.99),
(1010, 10, 1, 109.99),
(1011, 11, 1, 129.99),
(1012, 12, 1, 49.99),
(1013, 13, 1, 99.99),
(1014, 14, 1, 499.99),
(1015, 15, 1, 249.99);