This Content Management System application will allow a company's Human Resources department to interact with the information stored in their employees database. It is a command-line application that allows to view, add and update employees information.
A business owner would be able to organize and plan the company's productivity by managing departments, roles, managers, and staff.
The Employee Tracker has been created with MySQL Workbench, JavaScript, Node.js, and ES6+, the following NPM packages: MySQL, Inquirer, Console Table and Asciiart Logo as dependencies. The deployed interface will look like this:
To run the Employee Tracker you will need to install the provided package.json containing the required dependencies, then create the local MySQL database "employees.db" executing the provided "schema" and "seed" files with MySQL Workbench.
How this application can be used: Input node server.js to start the app. The following walk-through demo shows the app functionality:
When the application starts it displays a menu of actions, the arrow keys will allow the user to navigate through the options.
The application will display different tables from the database and / or will prompt questions depending on the user's request. See the following examples:
The following video demonstrates the entirety of the app's functionality:
MIT
Jon Phoenix
Application repository: https://github.com/JonPhoenix/employee-tracker
For further questions, please contact the author at: jonphx@uw.edu
* w3schools.com
* developer.mozilla.org
* mysql.com
* nodejs.org
* node.readthedocs.io
* npmjs.com
* screencastify.com