employee-tracker

Employee Tracker

Description

Database command-line application that allows for the organization and management of a department. This includes organizing data pertaining to employees as well as their roles of operation as performed within a business environment.

When application is started, the user is presented with the following options: View All Departments, View All Roles, View All Employees, Add a Department, Add a Role, Add an Employee, Update Employee Role, and Quit.

Selecting the ‘View All Departments’ option presents the user with a formatted table showing department names and department ids. Selecting the ‘View All Employees’ option presents the user with a formatted table showing employee data, including employee ids, first names, last names, job titles, departments, salaries, and managers that the employees report to. Selecting the ‘View All Roles’ option presents the user with the job title, role id, the department that role belongs to, and the salary for that role.

Selecting the option to add a department prompts the user to enter the name of the department and that department is added to the database. Selecting the option to add a role prompts the user to enter the name, salary, and department for the role and that role is added to the database. Selecting the option to add an employee prompts the user to enter the employee’s first name, last name, role, and manager, and that employee is added to the database.

Selecting the option to update an employee role prompts the user to select an employee to update and their new role and this information is updated in the database.

Installation

• npm
• inquirer
• mysql2
• console.table
• path

Usage

Provide options for business owners to organize information pertinent to personnel.

Website

Github: https://cphill11.github.io/employee-tracker/

https://github.com/cphill11/employee-tracker.git

Screencastify link: https://drive.google.com/file/d/1SY0HslbB1ZDxtMdc_XAlGYdc4vmDv-Qp/view

Image

Credits:

Criste Phillips

License

MIT

Badges

Contributing

Sticky paws off unless checking with original creator first. No exceptions.