Skip to content

This content management systems (CMS) is a command-line application to manage a company's employee database, using Node.js, Inquirer, and MySQL.

License

Notifications You must be signed in to change notification settings

thekhyatigandhi/employee-manager

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

22 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

EMPLOYEE MANAGER

License: MIT Node.js Badge Express Badge mysql

Description

This content management systems (CMS) is a command-line application to manage a company's employee database, using Node.js, Inquirer, and MySQL.

Application

The following video shows the application's appearance and functionality:

Screen.Recording.2023-05-30.at.4.04.17.PM.mov

Technologies Used

MySQL
Javascript
NODE JS
Express.js

Installation

Check if you have Node.js installed by typing "node -v" in your command line. If node is not installed, visit the Node.js website to install.
Next, clone this project repository to your computer. Use the command "npm install" to install dependecies. Create a file in the root directory titled ".env" and type "PASSWORD='[YOUR PASSWORD HERE]'"
Type "mysql -u root -p" in the terminal and enter your personal MySQL password.
Next, type "source schema.sql" and "source seeds.sql" (These commands will create the employee_db database and seed the database with mock data).

Usage

Open terminal in "index.js" and run the command "npm start".
Select a desired task and follow the Inquirer prompts.
Choose another task or exit the application.
To exit application, choose "EXIT" from task prompt list.
Reference the video demonstration above as needed.

Credits

https://nodejs.org/en
https://www.w3schools.com
https://www.w3schools.com/mysql/mysql_join.asp

License

MIT License. For more information on the license, please refer to the LICENSE file in the repo

About

This content management systems (CMS) is a command-line application to manage a company's employee database, using Node.js, Inquirer, and MySQL.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published