MySQL-Employee-Database

Employee-Tracker

Table of Contents

---

Description

License

Installation

Demo

Testing

Issues

Future Development

Contributors

GitHub

Contact

---

Description

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.

MySql database, contains departments, employees, roles

License

No license

Installation

* Install MySql2: 
    
    https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-install.html

* Type in terminal: 

    mysql -u root -p

*  Open a new terminal, and type: 

    npm install inquirer

Demo

Testing

npm start

Issues

• view all deptartments

• view roles

• view employees

• add department

• add role

• add employee

• update employee

• connection ends

Future_Development

• 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.

Contributors

Adam Campeau

GitHub

https://github.com/AdamCampeau

Contact

acampeau3@hotmail.com

ScreenCastify Link

https://watch.screencastify.com/v/vDseO7h49v3R5mHDxiCD

GitHub URL

https://adamcampeau.github.io/MySQL-Employee-Database/