data

INSERT INTO Employee (emp_no, emp_name, dob, address, mobile_no, dept_no, salary, Designation) VALUES 
    ('E001', 'Alice Johnson', '1985-03-15', '123 Elm St, Springfield', 1234567890, 'D001', 60000, 'HR Manager'),
    ('E002', 'Bob Smith', '1990-07-22', '456 Oak St, Capital City', 2345678901, 'D002', 75000, 'Financial Analyst'),
    ('E003', 'Carol Davis', '1988-10-05', '789 Pine St, Metropolis', 3456789012, 'D003', 80000, 'IT Specialist'),
    ('E004', 'David Brown', '1992-01-30', '321 Maple Ave, Townsville', 4567890123, 'D004', 55000, 'Marketing Executive'),
    ('E005', 'Emma Wilson', '1980-12-12', '654 Cedar Blvd, Cityville', 5678901234, 'D005', 72000, 'Operations Manager');
    
    
INSERT INTO Department (dept_no, dept_name) VALUES 
    ('D001', 'Human Resources'),
    ('D002', 'Finance'),
    ('D003', 'Information Technology'),
    ('D004', 'Marketing'),
    ('D005', 'Operations');
    
INSERT INTO Employee (emp_no, emp_name, dob, address, mobile_no, dept_no, salary, Designation) VALUES 
    ('E006', 'Frank Harris', '1987-05-11', '135 Willow St, Hilltown', 6789012345, 'D001', 58000, 'HR Coordinator'),
    ('E007', 'Grace Lee', '1993-09-24', '246 Birch St, Lakeside', 7890123456, 'D002', 72000, 'Financial Manager'),
    ('E008', 'Henry Wilson', '1982-06-30', '357 Spruce St, Rivertown', 8901234567, 'D003', 85000, 'Software Engineer'),
    ('E009', 'Isla Thompson', '1995-02-14', '468 Aspen St, Forestville', 9012345678, 'D004', 62000, 'Marketing Analyst'),
    ('E010', 'Jake Martinez', '1983-11-05', '579 Cherry Ave, Hillview', 1234567891, 'D005', 70000, 'Operations Analyst');