- Add new employees, roles, and departments to a company
- Assign new employees a manager
- View all employees, or filter view by role or department
- Update an employee's role
- Download project by clicking at the top of this repository, and open project directory in terminal.
- Install npm packages:
Inquirer
,Mysql
, optionalconsole.table
npm i inquirer npm i mysql npm i console.table
- Create database in MySQL using the provided schema located in
data
directory- (optional): Prepopulate with data from seed.sql file.
You may add your company's existing data in this file using the given models, or via the app)
mysql -u [your username] -p [enter password] source ./data/Company-Schema.sql source ./data/seed.sql (optional) exit
- (optional): Prepopulate with data from seed.sql file.
- Make sure to update the
app.js
file with your MySQL username & password
--> Walkthrough Video <--
- Run
node app
in terminal - Select an option from the menu & follow prompts to view or manage items in the company database
- Select
Exit
on main menu to exit the app
Contributions welcome!
- Fork this repository
- Create a new branch
- Commit/push your changes
- Create a new pull request
- Update an employee's manager
- View employees by manager
- DELETE employees/roles/deptartments from database
- View total utilized budget of a department
If you have any questions, feel free to create an Issue or contact me directly at dore.joel.dore@gmail.com
This project is MIT licensed.
© 2020 Joel Dore