dieterichelizabeth / my-employee-sql

A command-line application to manage a company's employee database 🧞‍♂️🧚‍♂️🐛

Hey there 👋 my name is Liz

• 🌱 I currently develop React applications and help maintain Wordpress sites
• 🌎 Lets connect on LinkedIn

my-employee-sql's Issues

Create Schema with 3 tables

department
id: INT PRIMARY KEY
name: VARCHAR(30) to hold department name

role
id: INT PRIMARY KEY
title: VARCHAR(30) to hold role title
salary: DECIMAL to hold role salary
department_id: INT to hold reference to department role belongs to (FOREIGN KEY)

employee
id: INT PRIMARY KEY
first_name: VARCHAR(30) to hold employee first name
last_name: VARCHAR(30) to hold employee last name
role_id: INT to hold reference to employee role (FOREIGN KEY)
manager_id: INT to hold reference to another employee that is the manager of the current employee (null if the employee has no manager) (FOREIGN KEY)

Bonus

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.

Require Inquirer and display prompts

Required prompts

view all departments
presents a formatted table showing department names and department ids

view all roles
presents the job title, role id, the department that role belongs to, and the salary for that role

view all employees
presents a formatted table showing employee data, including employee ids, first names, last names, job titles, departments, salaries, and managers that the employees report to

add a department
prompts user to enter the name of the department and that department is added to the database

add a role
prompts user to enter the name, salary, and department for the role and that role is added to the database

add an employee
prompts user to enter the employee’s first name, last name, role, and manager, and that employee is added to the database

and update an employee role
prompts user to select an employee to update and their new role and this information is updated in the database

Include Error handling

Add error handling to ensure prompts are adequately filled out

Modularize the sql commands

Use a constructor function or class to create a separate file that contains functions for performing specific SQL queries.

Connect the prompts to db

Create a connection between the database and inquirer prompts

Use Async/Await for database queries