Built with Node.js, Inquirer npm, MySQL
URL of the GitHub repository: https://github.com/TomFallon9/employee-management-system
This command line application allows user to easily view and manage the departments, roles, and employees in their company.
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.
User can clone this repository, make sure to have Node and MySQL installed.
Dependencies are Inquirer for collecting input from the user and MySQL to connect to the MySQL database and perform queries. To install the dependencies, run the following command:
npm i
Using this application, the user is able to do the following:
- Add departments, roles, employees
- View departments, roles, employees
- Update employee roles
- Update employee managers
- View employees by manager
Before running the command below, the schema.sql script should be executed in MySQL Workbench in order for the user to connect to the database. If you would like some starter data to demo your table you can add seeds.sql to your Workbench or Tableplus.
The application will be invoked with the following command:
node server.js
- Node.js - An open-source JavaScript runtime environment that executes JavaScript outside of the browser.
- MySQL - A database management system that is based on SQL – Structured Query Language.
- Inquirer
Copyright 2021 Thomas Fallon
Licensed under the MIT License