Skip to content

WITH CLASSES. 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.

Notifications You must be signed in to change notification settings

DiLiubarets/employeeTracker

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Employee Tracker

Using classes

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.

About

WITH CLASSES. 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.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published