设有如下4个关系模式：创建表并输入模拟数据。 部门表(部门号，部门名，办公地点，部门经理编号)外码：部门经理编号，参考职工表中职工号。 岗位表(岗位号、岗位名、岗位描述、岗位津贴)。 职工表（职工号，姓名，出生日期，性别，电话号码，入职日期，岗位号，部门号） 外码：岗位号，参考岗位表的岗位号，外码：部门号，参考部门表的部门号。 薪水表（薪水号，职工号，基本工资，岗位津贴，日期）职工号外码，参考职工表的职工号。

以下是使用 MySQL 数据库创建上述 4 个关系模式并输入模拟数据的示例步骤：

1. 创建职工表：

CREATE TABLE employees (
    employee_number INT PRIMARY KEY,
    name VARCHAR(255),
    birth_date DATE,
    gender CHAR(1),
    phone_number VARCHAR(255),
    hire_date DATE,
    job_number INT,
    department_number INT,
    FOREIGN KEY (job_number) REFERENCES jobs(job_number),
    FOREIGN KEY (department_number) REFERENCES departments(department_number)
);

2. 创建部门表：

CREATE TABLE departments (
    department_number INT PRIMARY KEY,
    department_name VARCHAR(255),
    location VARCHAR(255),
    manager_number INT,
    FOREIGN KEY (manager_number) REFERENCES employees(employee_number)
);

3. 创建岗位表：

CREATE TABLE jobs (
    job_number INT PRIMARY KEY,
    job_name VARCHAR(255),
    job_description TEXT,
    job_allowance DECIMAL(10,2)
);

4. 创建薪水表：

CREATE TABLE salaries (
    salary_number INT PRIMARY KEY,
    employee_number INT,
    base_salary DECIMAL(10,2),
    job_allowance DECIMAL(10,2),
    date DATE,
    FOREIGN KEY (employee_number) REFERENCES employees(employee_number)
);

5. 输入模拟数据：

INSERT INTO employees (employee_number, name, birth_date, gender, phone_number, hire_date, job_number, department_number)
VALUES (1, 'John Doe', '1990-01-01', 'M', '123-456-7890', '2020-01-01', 1, 1),
       (2, 'Jane Doe', '1995-01-01', 'F', '098-765-4321', '2020-01-01', 2, 1),
       (3, 'Bob Smith', '1985-01-01', 'M', '111-111-1111', '2020-01-01', 3, 2);

INSERT INTO departments (department_number, department_name, location, manager_number)
VALUES (1, 'Marketing', 'New York', 1),
       (2, 'Sales', 'Chicago', 3);

INSERT INTO jobs (job_number, job_name, job_description, job_allowance)
VALUES (1, 'Manager', 'Manages a team