Giter Club home page Giter Club logo

employee-tracker's Introduction

Employee Tracker

Table of Contents

The Employee Tracker is a command-line application that focuses on being a team management tool that allows a user to view and manipulate their team's information. A user can navigate through departments, roles, and employee information stored within a database system using nothing but command-line prompts.

User Story

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
  1. To install the required dependencies, run the following command:
npm install
  1. Make a copy of the .env.EXAMPLE file, change it to just .env and fill out the required fields with your MySQL info.
  2. Database, table creation and seed data has been provided within the db folder. Connect to MySQL in the command-line and run source db/schema.sql and source db/seeds.sql to manually seed the data from the provided scripts.

Demo of seeding data

Employee Tracker: Walkthrough Video

This app runs from the command line. After cloning the repo and installing dependencies, invoke application with:

npm start

Live Demo Gif

Contributors and feedback always welcome!

Project Technologies:

If you have any questions about the application, or would like to become a contributor, please contact me using the information below:

GitHub

employee-tracker's People

Contributors

blindsweatyhansolo avatar

Stargazers

 avatar

Watchers

 avatar

employee-tracker's Issues

Departments table

  • As a user, I can request a list of departments
  • Departments table consists of:
    -- ID
    -- NAME
  • As a user, I can ADD a department to the table.

BONUS

  • As a user, I can DELETE a department
  • As a user, I can request a list of the total utilized budget of a department (combined salaries of all employees by department)

Role table

  • As a user, I can request a list of roles
  • Role table consists of:
    -- ID
    -- TITLE
    -- SALARY
    -- DEPARTMENT (references department_id from DEPARTMENT table)
  • As a user, I can update an employee's role

BONUS

  • As a user, I can DELETE a role

Employees table

  • As a user, I can request a list of employees
  • Employees table consists of:
    -- ID
    -- FIRST NAME
    -- LAST NAME
    -- ROLE (references role table)
    -- MANAGERS (references manager table)
    -- SALARIES
  • As a user, I can update an employee's role.

BONUS

  • As a user, I can UPDATE an employee's managers
  • As a user, I can request a list of employees SORTED BY manager
  • As a user, I can request a list of employees SORTED BY department
  • As a user, I can DELETE an employee

Create database

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

  • As a user, I can request a list of all employees.

  • As a user, I can request a list of all departments.

  • As a user, I can request a list of all roles.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.