Created a command-line application to architect and build a solution for managing a company's employees using node, inquirer, and MySQL.
-
Created schemas for 3 tables: department, emmployee role and employee. Within those tables, foreign keys were utilized to hold references to department IDs, employee ID, and employee role IDs.
-
The app allows users to:
- View employees
- View Roles
- Add Employees
- Add Department
- Add Role
- Update Employee Role
- Remove Department
- Remove Roles
- Remove Employees
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
-
Used MySql NPM pacakge to connect MySql database and perform queries
-
Used Inquirer NPM package to interact with the user via the command-line
-
Used console.table to print MySql rowns to the console.
This project is licensed under the MIT License.