A Node.js CLI application that uses mySQL to create, read, update and delete departments, roles and employees from an SQL database.
For business owners who want to keep track of their companies departments, roles and employees with an easy to use interface that generates automatic sql queries to access the database for the company information.
Users can create or add new departments, roles and employees to the database and also assign a manager to the employee.
Employee Tracker allows the user to view the companies departments, roles and employees. Users can also view all employees that work under chosen managers. Utilised department budgets can also be viewed which shows the total salary expenditure of chosen departments.
If there are any changes that need to be updated to already existing department, roles and employee then this can be easily achieved by the user. Also if any existing departments, roles and employees need to be deleted from teh database then this can also be achieved with Employee Tracker.
-
Make sure Node.js is installed on your system.
-
Download the project as a zip file, unpack it where you would like it to be installed.
-
Open a terminal in the same folder and enter the following commands.
npm installnode index.js
Follow the on screen prompts and select which options you would like to perform.
- Node,js
- mySQL
- JavaScript
- Node module console.table
Link: https://drive.google.com/file/d/1YNm2BXA7QNyPnGhYkXmmUGHtYUJXpJPL/view?usp=sharing
