Employee Tracker
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, My challenge is to architect and build a solution for managing a company's employees using node, inquirer, and MySQL.
A video demonstration can be found on the following link: https://drive.google.com/file/d/1ZZi_AWocDF4PSqo_AABmACAxHapqBIBj/view
Design the following database schema containing three tables:
department:
id - INT PRIMARY KEY
name - VARCHAR(30) to hold department name
role:
id - INT PRIMARY KEY
title - VARCHAR(30) to hold role title
salary - DECIMAL to hold role salary
department_id - INT to hold reference to department role belongs to
employee:
id - INT PRIMARY KEY
first_name - VARCHAR(30) to hold employee first name
last_name - VARCHAR(30) to hold employee last name
role_id - INT to hold reference to role employee has
manager_id - INT to hold reference to another employee that manages the employee being Created. This field may be null if the employee has no manager
Build a command-line application that at a minimum allows the user to:
Add departments, roles, employees
View departments, roles, employees
Update employee roles
Bonus points if you're able to:
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
Node.js - JavaScript runtime environment
MySQLWorkbench - Visual database design tool
Dependencies
inquirer - For the CLI user interface. This will prompt user within the CLI for employee information.
console.table - Used to print MySQL into tables to the console.
mysql - Used to connect to the MySQL database and perform queries
promise-mysql - Used to create promises from MySQL queries
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ß
## Author
Rekha Kumari
Rekha Kumari © 2020. All rights reserved.