Employee-Tracker

Description
Mock-Up
Installation
Start the app
Questions

📝

Description

This app is using NodeJs and MySQL to creat an employee database. Using the SQL databse to creat a command-line application interfaces that allow non-developers to easily view and interact with information stored in databases.

🚀

Mock-Up

The following animation shows the database creation and seeding:

The following animation shows a mock-up of the app functionality:

Youtube videos to demonstrate the project

🔴📺

🛠️

installation

npm init
npm i

this will install the following dependencies

    "colors": "^1.4.0",
    "dotenv": "^10.0.0",
    "express": "^4.17.1",
    "inquirer": "^8.1.2",
    "mysql2": "^2.3.0"
  }

📚

Start the app

To start you may need to run the following command and answer the prompt question with an approperiate answer.

  mysql -u root -p

  source db/schema.sql;
  source db/seeds.sql;
  quit

npm start

❔

questions

You will be asked to do:

  * view all departments
  * view all roles
  * view all employees 
  * add a department
  * add a role
  * add an employee
  * update an employee role
  * exit

Technologies

Websites

Github: https://github.com/MehdiMahmud79/Employee-Tracker
Live: https://mehdimahmud79.github.io/Employee-Tracker/