Employee-Tracker

App is used for managing a company's employees using node, inquirer, and MySQL.

Abstract

Design the following database schema containing three 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

• 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 role employee has
  • manager_id - INT to hold reference to another employee that manages the employee being Created. This field may be null if the employee has no manager

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

Review

You are required to submit the following:

• The URL of the GitHub repository https://github.com/ru14/Employee-Tracker

• A video demonstrating the entirety of the app's functionality

zoom_0.mp4