A solution for managing a company's employees using node, inquirer, and MySQL
-
The command-line application allows users to:
- Add departments, roles, employees
- View departments, roles, employees
- Update employee roles
- View employees by manager
- Delete departments, roles, employees
- Use the CLI interface to select employee management options
- Menu options lead to additional prompts
- Options return to the home menu.
- Select the next option as needed.
- Use the Exit option to close the application.
-
Clone the repo
-
Install dependencies
npm install-
Create the database using the officeSchema.sql and seeds.sql files.
-
Run Server
node server.js- SQL queries for Create, Read, Update, and Delete (CRUD)
- Using NPM mysql module to interact with a MySQL backend
- Creating SQL schema and seed files