This is a command-line application to manage a company's employee database, using Node.js, Inquirer, and MySQL.
As a business owner, the user wants to view and manage the departments, roles, and employees in their company, so that they can organize and plan their business.
- About the Project
- Project Links
- Screenshots
- Demo
- Installation
- Contribution Guidelines
- Project Team
- Questions
- License
This is a command-line application which accepts user input. When the user starts the application, then they are presented with the following options:
- View all departments: user is presented with a formatted table showing department names and department ids.
- View all roles: user is presented with the job title, role id, the department that role belongs to, and the salary for that role.
- View all employees: presented 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.
- Add a department: user is prompted to enter the name of the department and that department is added to the database.
- Add a role: user is prompted to enter the name, salary, and department for the role and that role is added to the database.
- Add an employee: user is prompted to enter the employee’s first name, last name, role, and manager, and that employee is added to the database.
- And update an employee role: user is prompted to select an employee to update and their new role and this information is updated in the database.
- Update employee managers.
- View employees by manager.
- View employees by department.
- Delete departments, roles, and employees.
- View the total utilized budget of a department –in other words, the combined salaries of all employees in that department.
git clone https://github.com/SepidehAyani/employee_tracker.git
Note: follow this to install MySql and setup your own username & password
Feel free to contribute to this repo by creating issues or sending an email to sepid.ayani@gmail.com