/Employee-Tracker

Command-line application that allows you to: Add departments, roles, employees. View departments, roles, employees. Update employee roles. Update employee managers. View employees by manager. Delete departments, roles, and employees.

Primary LanguageJavaScript

Employee Tracker

Design the following database schema containing three tables:

Database Schema Employee Tracker Youtube video

  • department:

    • id - INT PRIMARY KEY
    • name - VARCHAR(30) to hold department name

  • role:

    • id - INT PRIMARY KEY
    • title - VARCHAR(30) to hold role title
    • salary - DECIMAL to hold role salary
    • department_id - INT to hold reference to department role belongs to

  • employee:

    • id - INT PRIMARY KEY
    • first_name - VARCHAR(30) to hold employee first name
    • last_name - VARCHAR(30) to hold employee last name
    • role_id - INT to hold reference to role employee has
    • manager_id - INT to hold reference to another employee that manager of the current employee. This field may be null if the employee has no manager

Command-line application that allows you to:

  • Add departments, roles, employees

  • View departments, roles, employees

  • Update employee roles

  • Update employee managers

  • View employees by manager

  • Delete departments, roles, and employees

  • View the total utilized budget of a department -- ie the combined salaries of all employees in that department

NPM packages:

  • MySQL NPM package to connect to your MySQL database and perform queries.

  • InquirerJs NPM package to interact with the user via the command-line.

  • console.table to print MySQL rows to the console. There is a built-in version of console.table, but the NPM package formats the data a little better for our purposes.