Create Schema file for:

• employee table
• role table
• department table

Create seed file to populate tables

• Make sure foreign key references are working
• test a few queries in the command line

• Update employee managers
• View employees by manager
• View employees by department
• Delete departments, roles, and employees
• View the total utilized budget of a department ( ie the combined salaries of all employees in that department)

• Create function to connect to database
• Create scripts in package.json to migrate and seed the database
• Test basic sql calls from node server.js

• view all departments,
• view all roles,
• view all employees,
• add a department,
• add a role,
• add an employee,
• and update an employee role

Render results to the console in table format

Create Prompts for the following flow:

• view all departments
• view all roles
• view all employees
• add a department
  • enter the name of the department
  • and department is added to the database
• add a role
  • enter the name
  • salary
  • department for the role
  • and that role is added to the database
• add an employee
  • enter the employee’s first name
  • last name
  • role
  • manager
  • and that employee is added to the database
• update an employee role
  • select an employee to update
  • their new role
  • and information is updated in the database