text: CREATE TABLE "departments" (
      "dept_no" varchar(4)   NOT NULL,
      "dept_name" varchar (50)   NOT NULL,
      PRIMARY KEY ("dept_no"),
      UNIQUE      ("dept_name")
  );
  
  
  CREATE TABLE "salaries" (
      "emp_no" integer   NOT NULL,
      "salary" integer   NOT NULL,
      "from_date" date   NOT NULL,
      "to_date" date   NOT NULL,
      foreign key (emp_no) references employees(emp_no),
      PRIMARY KEY (emp_no, from_date)
  );
  
  CREATE TABLE "employees" (
      "emp_no" integer   NOT NULL,
      "birth_date" date   NOT NULL,
      "first_name" varchar   NOT NULL,
      "last_name" varchar   NOT NULL,
      "gender" varchar(1)   NOT NULL,
      "hire_date" date   NOT NULL,
      PRIMARY KEY (emp_no)
  );
  
  CREATE TABLE "titles" (
      "emp_no" integer   NOT NULL,
      "title" varchar   NOT NULL,
      "from_date" date   NOT NULL,
      "to_date" date   NOT NULL,
      foreign key (emp_no) references employees (emp_no),
      PRIMARY KEY (emp_no, from_date)
  );
  
  CREATE TABLE "dept_emp" (
      "emp_no" integer   NOT NULL,
      "dept_no" varchar(4)   NOT NULL,
      "from_date" date   NOT NULL,
      "to_date" date   NOT NULL,
     FOREIGN KEY (emp_no)  REFERENCES employees (emp_no),
     FOREIGN KEY (dept_no) REFERENCES departments (dept_no),
     PRIMARY KEY (emp_no,dept_no)
  );
  
  CREATE TABLE dept_manager (
     dept_no      VARCHAR(4)         NOT NULL,
     emp_no       INT             NOT NULL,
     from_date    DATE            NOT NULL,
     to_date      DATE            NOT NULL,
     FOREIGN KEY (emp_no)  REFERENCES employees (emp_no),
     FOREIGN KEY (dept_no) REFERENCES departments (dept_no),
     PRIMARY KEY (emp_no,dept_no)
  );