Employee Tracker - Yet another employee tracker command line application

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. In this homework assignment, the challenge is to architect and build a solution for managing a company's employees using node, inquirer, and MySQL.

Employee Tracker - Yet another employee tracker command line application

Installation

Clone this GitHub repository

git clone git@github.com:harishnarain/employee-tracker.git

Install all dependent npm packages
```
npm install --save
```
Create the employee_db database running the script sql-scripts/0_createdb.sql in MySQL
Create the departments table running the script sql-scripts/1_departments.sql in MySQL
Create the roles table running the script sql-scripts/2_roles.sql in MySQL
Create the employees table running the script sql-scripts/3_employees.sql in MySQL
Seed mock data running the script sql-scripts/4_seed.sql in MySQL

Usage

Run npm start to start the application
Choose Employee, Role or Department management categories and use the submenus to run the appropriate operations

Features

Display all employees
Display employees by department
Display employees by manager
Display roles
Display departments
Display utilized budget of department
Add employees
Add managers
Add roles
Add departments
Delete employees
Delete roles
Delete departments
Update employee's role
Update employee's department

License

This project uses the MIT license

Contributing

Pull requests are welcome

Screenshots

View operations

Add operations

Update operations

Delete operations

Questions

Checkout my GitHub profile

Please feel free to email at: harishnarain@gmail.com

harishnarain/employee-tracker