employee-database

License:

MIT

Table of Contents

* Description

* Installation

* Usage

* Contributing

* Tests

* Questions

Description

This application manages a company's employee database using Node.js, Inquirer and MySQL while using the command line.

Installation

Clone the repository. Run npm install in the terminal to install dependencies. Run node index.js in the command line of the terminal to start the application.

Usage

Upon running "npm install" then "node index.js" in the terminal, the application will present the following options: view all departments, view all roles, view all employees, add a department, add a role, add an employee, and update employee role.

"View All Departments" will present a formatted table showing department names and department ids.

"View All Roles" will present the job title, role id, the department that the role belongs to, and the salary for that role.

"View All Employees" will present a formatted table showing employee data, including employee ids, first names, last names, job titles, departments, salaries, and managers that the employees report to.

"Add a Department" will allow you to enter the name of the department and that department is added to the database.

"Add a Role" will allow you to enter the name, salary, and department for the role and that role is added to the database.

"Add an Employee" will allow you to enter the employee’s first name, last name, role, and manager, and that employee is added to the database.

"Update an Employee Role" will allow you to select an employee to update and their new role and this information is updated in the database.

Contributing

Please refer to contact details if you would like to contribute to the project.

Tests

N/A

Questions

If you have any questions, contact me at

GitHub: https://github.com/https://github.com/romeocd

Email: rdumlao07@gmail.com

Video Demonstration

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

Screenshot