text: CREATE TABLE "Employees" (
      "emp_no" INTEGER   NOT NULL,
      "emp_title_id" VARCHAR   NOT NULL,
      "birth_date" VARCHAR   NOT NULL,
      "first_name" VARCHAR   NOT NULL,
      "last_name" VARCHAR   NOT NULL,
      "sex" VARCHAR   NOT NULL,
      "hire_date" VARCHAR   NOT NULL,
      CONSTRAINT "pk_Employees" PRIMARY KEY (
          "emp_no"
       )
  );
  
  CREATE TABLE "Employee_Dept" (
      "emp_no" INTEGER   NOT NULL,
      "dept_no" VARCHAR   NOT NULL,
      CONSTRAINT "pk_Employee_Dept" PRIMARY KEY (
          "dept_no"
       )
  );
  
  CREATE TABLE "Departments" (
      "dept_no" VARCHAR   NOT NULL,
      "dept_name" VARCHAR   NOT NULL
  );
  
  CREATE TABLE "Titles" (
      "title_id" VARCHAR   NOT NULL,
      "title" VARCHAR   NOT NULL,
      CONSTRAINT "pk_Titles" PRIMARY KEY (
          "title_id"
       )
  );
  
  CREATE TABLE "Dept_Manager" (
      "dept_no" VARCHAR   NOT NULL,
      "emp_no" INTEGER   NOT NULL
  );
  
  CREATE TABLE "Salaries" (
      "emp_no" INTEGER   NOT NULL,
      "salary" INTEGER   NOT NULL
  );
  
  ALTER TABLE "Employees" ADD CONSTRAINT "fk_Employees_emp_title_id" FOREIGN KEY("emp_title_id")
  REFERENCES "Titles" ("title_id");
  
  ALTER TABLE "Employee_Dept" ADD CONSTRAINT "fk_Employee_Dept_emp_no" FOREIGN KEY("emp_no")
  REFERENCES "Employees" ("emp_no");
  
  ALTER TABLE "Departments" ADD CONSTRAINT "fk_Departments_dept_no" FOREIGN KEY("dept_no")
  REFERENCES "Employee_Dept" ("dept_no");
  
  ALTER TABLE "Dept_Manager" ADD CONSTRAINT "fk_Dept_Manager_dept_no" FOREIGN KEY("dept_no")
  REFERENCES "Employee_Dept" ("dept_no");
  
  ALTER TABLE "Dept_Manager" ADD CONSTRAINT "fk_Dept_Manager_emp_no" FOREIGN KEY("emp_no")
  REFERENCES "Employees" ("emp_no");
  
  ALTER TABLE "Salaries" ADD CONSTRAINT "fk_Salaries_emp_no" FOREIGN KEY("emp_no")
  REFERENCES "Employees" ("emp_no");
  
  