text: -- 1. Data Modeling
  -- Inspect the CSVs and sketch out an ERD of the tables. Feel free to use a tool like
  
  -- 2. Data Engineering
  -- Use the information you have to create a table schema for each of the six CSV files
  
  -- DROP TABLE "departments","dept_emp","dept_manager","employees","salaries","titles";
  
  -- Exported from QuickDBD: https://www.quickdatabasediagrams.com/
  -- NOTE! If you have used non-SQL datatypes in your design, you will have to change these here.
  
  -- Exported from QuickDBD: https://www.quickdatabasediagrams.com/
  -- NOTE! If you have used non-SQL datatypes in your design, you will have to change these here.
  
  -- CREATE TABLE "departments" (
  --     "dept_no" VARCHAR   NOT NULL,
  --     "dept_name" VARCHAR   NOT NULL,
  --     CONSTRAINT "pk_departments" PRIMARY KEY (
  --         "dept_no"
  --      )
  -- );
  
  -- CREATE TABLE "dept_emp" (
  --     "emp_no" INT   NOT NULL,
  --     "dept_no" VARCHAR   NOT NULL
  -- );
  
  -- CREATE TABLE "dept_manager" (
  --     "dept_no" VARCHAR   NOT NULL,
  --     "emp_no" INT   NOT NULL
  -- );
  
  -- CREATE TABLE "employees" (
  --     "emp_no" INT   NOT NULL,
  --     "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 "salaries" (
  --     "emp_no" INT   NOT NULL,
  --     "salary" INTEGER   NOT NULL
  -- );
  
  -- CREATE TABLE "titles" (
  --     "title_id" VARCHAR   NOT NULL,
  --     "title" VARCHAR   NOT NULL,
  --     CONSTRAINT "pk_titles" PRIMARY KEY (
  --         "title_id"
  --      )
  -- );
  
  -- ALTER TABLE "dept_emp" ADD CONSTRAINT "fk_dept_emp_emp_no" FOREIGN KEY("emp_no")
  -- REFERENCES "employees" ("emp_no");
  
  -- ALTER TABLE "dept_emp" ADD CONSTRAINT "fk_dept_emp_dept_no" FOREIGN KEY("dept_no")
  -- REFERENCES "departments" ("dept_no");
  
  -- ALTER TABLE "dept_manager" ADD CONSTRAINT "fk_dept_manager_dept_no" FOREIGN KEY("dept_no")
  -- REFERENCES "departments" ("dept_no");
  
  -- ALTER TABLE "dept_manager" ADD CONSTRAINT "fk_dept_manager_emp_no" FOREIGN KEY("emp_no")
  -- REFERENCES "employees" ("emp_no");
  
  -- ALTER TABLE "employees" ADD CONSTRAINT "fk_employees_title_id" FOREIGN KEY("title_id")
  -- REFERENCES "titles" ("title_id");
  
  -- ALTER TABLE "salaries" ADD CONSTRAINT "fk_salaries_emp_no" FOREIGN KEY("emp_no")
  -- REFERENCES "employees" ("emp_no");