Skip to content

Allows users to help manage departments, roles, and employees in their company.

License

Notifications You must be signed in to change notification settings

blanchardt/trevors-company-manager

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

18 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

trevors-company-manager

License: MIT

Description

Allows users to help manage departments, roles, and employees in their company.
Walkthrough Video:
https://drive.google.com/file/d/1T5jTzJydVmtG8hfKBJB8u8V_J5SyFNIF/view?usp=sharing
Example of responsives:
view the departments, roles, and employees.
answer responses for adding a department.
answer responses for adding a role.
answer responses for adding an employee.

Table of Contents

Installation

To install necessary dependencies, run the following command:

npm install  
npm i inquirer@8.2.4  

Credits

Created by: Trevor Blanchard
Link to repo: https://github.com/blanchardt/trevors-company-manager

server.js

line 111:
Went to https://stackoverflow.com/questions/17434929/joining-two-tables-with-specific-columns to learn how to not have duplicate column names.
Natalia Natalie, OCDan, Fenton, user1864610, user1978081, Md Yeasin Arafat, Gordon Linoff, Riv, Nicolas Gervais,
     4b0, & Sudipta Mondal. (2013, July 2). Joining two tables with specific columns. Stack Overflow.
     https://stackoverflow.com/questions/17434929/joining-two-tables-with-specific-columns

line 192-195:
went to https://www.w3schools.com/sql/sql_join_self.asp to learn how to self JOIN. also credited in the readme file.
SQL Self Join. SQL Self join. (1999). https://www.w3schools.com/sql/sql_join_self.asp

line 192-195:
went to https://learnsql.com/blog/concatenate-two-columns-in-sql/#:~:text=The%20CONCAT_WS%20function%20in%20SQL,strings%20you%20want%20to%20concatenate.
to figure out how to combine 2 columns into a single column.
Bruffa, A. (2023, February 16). How to concatenate two columns in SQL – A detailed guide. LearnSQL.com.
     https://learnsql.com/blog/concatenate-two-columns-in-sql/#:~:text=The%20CONCAT_WS%20function%20in%20SQL,strings%20you%20want%20to%20concatenate.

line 192-195:
went to https://www.educative.io/answers/how-to-join-3-or-more-tables-in-sql to learn how to join multiple tables together. also credited in the readme file.
How to join 3 or more tables in SQL. Educative, Inc. (2023).
     https://www.educative.io/answers/how-to-join-3-or-more-tables-in-sql

line 540-542:
Went to https://stackoverflow.com/questions/43003870/how-do-i-shut-down-my-express-server-gracefully-when-its-process-is-killed to figure out the
comand to quit out of the program while it is running on a port.
Patrick Hund, Slava Fomin II, Przemek Nowak, Erick, Adarsh Madrecha, LeoPucciBr, twg, & Rafael Tavares. (2017,
     March 24). How do I shut down my express server gracefully when its process is killed?. Stack Overflow.
     https://stackoverflow.com/questions/43003870/how-do-i-shut-down-my-express-server-gracefully-when-its-process-is-killed

Usage

Nothing

License

This project is licensed under the MIT license.

Contributing

Nothing

Questions

If you have any questions about the repo, open an issue or contact me directly at blanchardt@merrimack.edu. You can find more of my work at blanchardt.

About

Allows users to help manage departments, roles, and employees in their company.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages