CREATE TABLE Employees ( 
    EmployeeID INT AUTO_INCREMENT PRIMARY KEY, 
    FirstName VARCHAR(30), 
    LastName VARCHAR(30), 
    DepartmentID INT
    ); 

CREATE TABLE Department ( 
    DepartmentID INT AUTO_INCREMENT PRIMARY KEY, 
    DepartmentName VARCHAR(30),
    Location VARCHAR(30), 
    ParentDepartmentID INT,
    FOREIGN KEY (ParentDepartmentID) REFERENCES Department(DepartmentID)
    );

CREATE TABLE Location ( 
    LocationID INT AUTO_INCREMENT PRIMARY KEY, 
    StateName VARCHAR(30), 
    CityName VARCHAR(30), 
    ZipCode INT UNIQUE
    );


INSERT INTO (EmployeeID, FirstName, LastName)VALUES
(1,'Alice', 'Johnson'), 
(2,'Bob', 'Smith'),
(3,'Carol', 'Lee'), 
(4,'David', 'Kim'), 
(5, 'Eva', 'Brown'), 
(6, 'Frank', 'White'), 
(7, 'Grace', 'Green');


INSERT INTO (DepartmentID, DepartmentName, Location)
(20002, "IT" , "Kansas"), 
(20004, 'Finance', 'Florida'), 
(20006, 'Human Resources', 'Kansas');