tracker_of_adepts

Unit 12 MySQL Homework: Employee Tracker

Developers are often tasked with creating interfaces that make it easy for non-developers to view and interact with information stored in databases. Often these interfaces are known as Content Management Systems. In this we have built a solution for managing a company's employees using node, inquirer, and MySQL.

Usage

This application allows the user to:

• Add departments, roles, employees

• View departments, roles, employees

• Update employee roles

Future Development:

• Update employee managers

• View employees by manager

• Delete departments and roles

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

User Story

As a business owner
I want to be able to view and manage the departments, roles, and employees in my company
So that I can organize and plan my business

NPM Packages Used

• MySQL

• InquirerJs

• console.table

Technology Used

• MySQL

• Javascript

• jQuery

Demo

https://drive.google.com/file/d/1bcabkeaxbmnuyVS3PCxmLsdSGKG8FPVv/view

Future Development

• The command-line application should allow users to:

  • 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