/cli-employee-tracker-app

A command line interface application that administers the company's employee database (by dept, roles & other user input data) using Node.js, npm & MySQL.

Primary LanguageJavaScriptMIT LicenseMIT

  _____                 _                         _____               _                  _                
 | ____|_ __ ___  _ __ | | ___  _   _  ___  ___  |_   _| __ __ _  ___| | _____ _ __     / \   _ __  _ __  
 |  _| | '_ ` _ \| '_ \| |/ _ \| | | |/ _ \/ _ \   | || '__/ _` |/ __| |/ / _ \ '__|   / _ \ | '_ \| '_ \ 
 | |___| | | | | | |_) | | (_) | |_| |  __/  __/   | || | | (_| | (__|   <  __/ |     / ___ \| |_) | |_) |
 |_____|_| |_| |_| .__/|_|\___/ \__, |\___|\___|   |_||_|  \__,_|\___|_|\_\___|_|    /_/   \_\ .__/| .__/ 
                 |_|            |___/                                                        |_|   |_|

CLI : Employee Tracker App

mit-license npm-mysql2 npm-inquirer npm-easy-table npm-dotenv

Description

A command-line application to get access to the company's database using Nodejs and connects the data from MySQL, which you can able to view company's details for departments, roles, employees and also add roles/dept/employee.

The app was able to connect to the database and update command terminal using an asynchronous function. Using MySQL queries to SELECT the data from tables, JOIN the fields coming from different tables and INSERT the data entered from the CLI.

Walkthrough Video

User Story

module-12 As a business owner, I need an app where I will be able to view and manage the departments, roles, and employees in the company. So That I can organize and plan the business.

Application

  • npm packages (inquirer, mysql2, easy-table, dotenv)
  • run Node.js in CLI
  • MySQL to create new schema & tables

Table of Contents

  1. ERD
  2. Demo
  3. Github Link
  4. Feedback or Contribute
  5. License
  6. Reference

ERD

Entity Relationship Diagram for employee tracker app, using SQL relationship.

employee-tracker-app-erd

Demo

  • Employee Tracker App : CLI

cli-in-ide

  • Employee Tracker App : MySQL

mysql-raw-data

Github Link

Profile Link: github-badge

Feedback or Contribute

If you have any feedback or suggestion feel free to send an email, codingowl898@gmail.com

License

All rights reserved. Under the MIT license.

Reference

License Badge, instructor Sam for some guided syntax code, ASCII-Text, Diagram