Skip to content

sarawrmas/employee-tracker

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Employee Tracker

Table of Contents

Description

As a business owner, it would be helpful to be able to view and manage the departments, roles, and employees in your company and organize and plan your business. Employee Tracker is here to help you keep everything organized and updated. The ability to find what you're looking for is right at your fingertips, all in one simple command prompt application.

Languages

This application was built using:

  • JavaScript
  • Node/NPM
  • Inquirer
  • SQL
  • MySQL2

Installation

  1. Copy Link: Hit the "Code" button within this GitHub repo to copy link.
  2. Clone: Use the command "git clone paste link here".
  3. NPM: Run the command "npm install" to install Node Package Manager and the following dependencies from the package.json file:
  • inquirer
  • MySQL2
  • console.table
  1. MySql:
  • In integrated terminal, use "mysql -u username -p"
  • Enter your MySQL password to login
  • Download database and tables to your remote workspace from the 'db' folder using commands:
    • 'source db/db.sql'
    • 'source db/schema.sql'
    • 'source db/seeds.sql'

Usage

After following installation instructions, navigate to your integrated terminal and begin the prompt using the command 'npm start' or 'node index.js.'

From the main menu, select your desired option:

  • View all departments
  • View all roles
  • View all employees by manager
  • View all employees by department
  • View utilized budget by department
  • Add a department
  • Add a role
  • Add an employee
  • Update an employee role
  • Remove a department
  • Remove a role
  • Remove an employee

Follow the prompts to add, update, or remove if chosen or simply select from the view list to access your tables.

Each selection, once completed, will bring you back to the main menu. To finish your session, simply close the terminal.

Demonstration

Would you like to see the Employee Tracker in action?

Watch this demo.

Questions

Have questions about this project?
GitHub: https://github.com/sarawrmas
Email: sara.m.adamski@gmail.com

Credits

Sara Adamski

About

Back end employee tracker using SQL commands.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published