To install, please clone this repository to your computer using the following steps in Github:
- Click the "Code" dropdown menu and copy the SSH URL.
- Open your terminal and navigate to the directory you would like to clone this repository into.
- Type "git clone ", replacing with your copied SSH URL. You can substitute an SSH URL with an HTTPS URL.
- Press enter.
This is an node/SQL-based employee tracking program that creates a database tracking yor company's departments, roles and employees via a SQL database.
Using inquirer terminal commands, the user is not only able to view the company's departments, roles, and employees, but also add departments, roles, and employees. You can also update an employee's role within the company.
First, ensure that the SQL database "company" is running by entering the following commands via the terminal:
psql -U postgres \i database/schema.sql \i database/seeds.sql \dt
Once you have confirmed the database is running, navigate to server.js in your terminal and enter "node server.js" to get the program running.
In your terminal, a list of commands will appear that you can navigate to. To select, scrolling over the desired command and press "enter."
If you select "Add a department," follow the prompt to enter the name for the new department you are adding to the database.
If you select "Add a role," follow the prompts to enter the name, salary, and department for the new role you are adding to the database.
If you select "Add an employee," follow the prompts to enter the first name, last name, department, and manager for the new employee you are adding to the database.
If you select "Update an employee role," follow the prompts to select the employee and the employee's new role.
To exit the program, select "Exit" in the main list of prompts.
Please see this video demo. If unable to view, you can also find the video in assets/videos/screenrecording1.mov.
When contributing to this repository, please reach out to me via e-mail to discuss the change you would like to make first. I am open to ideas both with regards to data stored in the tables and alterations to user interaction with the data.
This project is licensed under the MIT License. For more information, please see the MIT License.
This program was created by Jacob McAuliffe for the UC Berkeley eDX Coding Boot Camp.
In the future, I would like to incorporate both more data within the tables, and further opportunities for user interaction with this data. Ideas for further data within the table include employment start date, list of any recognitions, vacation time available for the employee, annual bonus. Ideas for user interaction include being able to delete data from the tables, or extra data to create sub-tables within the database as needed.
If you have further questions, you can reach me at [email protected].
GitHub Account: jacobmca