jkaho / employee-tracker

Command-line CMS for keeping track of employee data

Employee Tracker

Description

Employee Tracker is a command-line content management system (CMS) application that allows users to add, view, update and delete data relating to employees, roles and departments.

Table of Contents

• Installation
• Video Walkthrough
• Technologies Used
• Application User Interface
• Questions

Installation

1. Clone this repository onto your local computer
2. Using the MySQL server, run the 'schema.sql' file (db/schema.sql) to create the application database
3. (Optional) For testing purposes, run the 'seed.sql' file (db/seed.sql) to pre-populate the database with dummy data
4. In the command line, navigate to the cloned repository (the 'employee-tracker' directory)
5. Install the required dependencies by running the command: npm install
6. Open the 'index.js' file and change the password on line 15 to your own MySQL root password

Video Walkthrough

Click here to view a video walkthrough of the application functionality.

Technologies Used

• SQL
• MySQL Workbench
• MySQL Community Server
• JavaScript
• Node.js
• npm mysql package
• npm inquirer package
• npm console.table package
• npm chalk package

Application User Interface

Questions

My GitHub Profile: jkaho

If you have any further questions, please feel free to email me at [email protected]