Skip to content

This is a command line Application that allows user to architect and build a solution for managing a company's employees. using node, express, and MySQL.

Notifications You must be signed in to change notification settings

mauricechouam/Employee-Tracker

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

22 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Employee-Tracker

GitHub license

Command Line Application that allows user to architect and build a solution for managing a company's employees. using node, inquirer, and MySQL.

Table of Contents

User Story

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

Instructions

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 manager of the current employee. This field may be null if the employee has no manager

Acceptance Criteria

  • Functional application.

  • GitHub repository with a unique name and a README describing the project.

  • The command-line application should allow users to:

    • Add departments, roles, employees

    • View departments, roles, employees

    • Update employee roles

Helpful links

  • Use the MySQL NPM package to connect to your MySQL database and perform queries.

  • Use InquirerJs NPM package to interact with the user via the command-line.

  • Use console.table to print MySQL rows to the console. There is a built-in version of console.table, but the NPM package formats the data a little better for our purposes.

About

This is a command line Application that allows user to architect and build a solution for managing a company's employees. using node, express, and MySQL.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published