The goal was to architect and build a solution for managing a company's employees using node, inquirer, and MySQL. 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.
The app involved building a command-line application that allows the user to:
- Add departments, roles, employees
- View departments, roles, employees
- Update employee roles
- 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
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
i. Fork the Github repository.
ii. Clone the forked repo into your local machine using gitbash/terminal to pull the project and data.
iii. Run the command-lines below in your terminal to run the app functionality. You can also access the files and assets via Visual Studio to view the code.
iv. Command-lines: 1) npm install // 2) node EmployeeTracker.js to run the app // 3) App runs on http://localhost:3000
v. Use the Employee Tracker app: add/view/update/delete departments, roles, employees
Key Components Used:
MySQL - InquirerJs - console.table - Node.js - JavaScript - SQL Joins
- Below are screenshots of the application functionality and schema:
Pull requests are welcome. Please use the Contributor Covenant Code of Conduct and for major changes, please open an issue beforehand to discuss the changes.
Have questions? Contact me at: