-- Create Departments Table CREATE TABLE Departments ( DepartmentID INT PRIMARY KEY AUTO_INCREMENT, DepartmentName VARCHAR(100) NOT NULL );

-- Create Employees Table CREATE TABLE Employees ( EmployeeID INT PRIMARY KEY AUTO_INCREMENT, FirstName VARCHAR(50) NOT NULL, LastName VARCHAR(50) NOT NULL, DepartmentID INT, HireDate DATE, FOREIGN KEY (DepartmentID) REFERENCES Departments(DepartmentID) );

-- Create Salaries Table CREATE TABLE Salaries ( SalaryID INT PRIMARY KEY AUTO_INCREMENT, EmployeeID INT, SalaryAmount DECIMAL(10, 2) NOT NULL, EffectiveDate DATE, FOREIGN KEY (EmployeeID) REFERENCES Employees(EmployeeID) );