MySQL Employee Management System

Table of Contents

• Description
• Links
• Installation Instructions
• Usage
• Technologies Used
• Tests
• Credits
• Contributing
• Questions
• Badges

Description

This is a CLI employee management system application using Inquirer.js and MySQL. This system allows the user to add employees, departments, and roles; view employees (all, by department, by manager, and by role), departments, and roles; view departments' utilized budgets; update employee managers and roles; and delete employees and roles. After drilling down into the containing folder, the user should run "npm install", then open the process by entering "node server.js", at which point the application will ask the user to select a function, then walk the user through prompts to execute the selected function.

Links

Link to walkthrough video

Alternate link to walkthrough video

Installation Instructions

If you want to run a copy of this app on your local machine, you will need to install MySQL Workbench from the MySQL website here:

https://dev.mysql.com/downloads/mysql/

You will need to configure MySQL Workbench before using it. Instructions can be found here:

https://dev.mysql.com/doc/workbench/en/wb-mysql-connections.html

Then, clone the repository:

HTTPS:

$ git clone https://github.com/LauraCole1900/mysqlEmployeeTracker.git

SSH:

$ git clone git@github.com:LauraCole1900/mysqlEmployeeTracker.git

Then cd/ into the cloned directory and download the dependencies by typing into the command line

$ npm install --save

Once the dependencies and MySQL Workbench are installed and MySQL Workbench is configured, start the application by typing into the command line

$ node server.js

Usage

This application is intended to be used to track employees, departments, and roles for an organization.

Technologies Used

Tests

npm run test

Credits

N/A

Contributing

We believe code is never finished, welcome your contributions to enhance the applications functionality. Please adhere to the Code of Conduct for the Contributor Covenant, version 2.0, at https://www.contributor-covenant.org/version/2/0/code_of_conduct.html.

Questions

If you have further questions, you can reach me at lauracole1900@comcast.net. For more of my work, see my GitHub.

Badges