text: CREATE DATABASE test_database;
  
  # @Create 6/27/2021
  
  USE test_database;
  CREATE TABLE IF NOT EXISTS DEPARTMENTS
  (
      department_id BIGINT      NOT NULL AUTO_INCREMENT PRIMARY KEY,
      title         VARCHAR(64) NOT NULL UNIQUE,
      description   VARCHAR(255)
  );
  
  USE test_database;
  CREATE TABLE IF NOT EXISTS EMPLOYEES
  (
      employee_id     BIGINT       NOT NULL AUTO_INCREMENT PRIMARY KEY,
      first_name      VARCHAR(32)  NOT NULL,
      last_name       VARCHAR(32)  NOT NULL,
      email           VARCHAR(255) NOT NULL UNIQUE,
      salary_per_hour DECIMAL(7),
      date_of_birth   DATE,
      head            TINYINT(1),
      department_id   BIGINT       NULL REFERENCES DEPARTMENTS (department_id)
  );
  
  INSERT INTO DEPARTMENTS(title, description)
  VALUES ('Grove Street Families',
          'The Grove Street Families is an African-American street gang and one of the oldest street gangs in Los Santos, San Andreas.'),
         ('Ballas',
          'The Ballas have been around since the 1970s. Specific information regarding where or how they formed is unknown.'),
         ('Los Santos Police Department',
          'The Los Santos Police Department (LSPD) is the primary law enforcement agency of the city of Los Santos, San Andreas'),
         ('San Fierro Triads',
          'The San Fierro Triads are a gang originating from Hong Kong, who have since moved to San Fierro.'),
         ('Los Santos Vagos',
          'The Los Santos Vagos (a.k.a Northside Vagos, Northerners, LSV, or just the Vagos) are a street gang');
  
  INSERT INTO EMPLOYEES(first_name, last_name, email, salary_per_hour, date_of_birth, head, department_id)
  VALUES ('Carl', 'Johnson', 'cj@gmail.com', 250000, '1968-05-03', 1, 1),
         ('Sean', 'Johnson', 'sweet@gmail.com', 30, '1966-03-11', 0, 1),
         ('Melvin', 'Harris', 'bigsmoke@yahoo.com', 100, '1967-10-29', 0, 1),
         ('Lance', 'Wilson', 'ryder@yahoo.com', 50, '1963-06-24', 0, 1),
  
         ('Little', 'Weasel', 'littleweasel@yahoo.com', 50, '1978-01-01', 0, 2),
  
         ('Frank', 'Tenpenny', 'officertenpenny@gmail.com', 80, '1958-11-12', 1, 3),
         ('Edward', 'Pulaski', 'officerpulaski@gmail.com', 80, '1956-02-27', 0, 3),
  
         ('Ran Fa', 'Li', 'ranfali@yahoo.com', 150, '1945-01-01', 1, 4),
         ('WuZi', 'Mu', 'wuzimu@gmail.com', 125, '1965-01-08', 0, 4),
  
         ('Big', 'Poppa', 'bigpoppa@gmail.com', 25, '1960-02-04', 1, 5);