As a business owner, it would be helpful to be able to view and manage the departments, roles, and employees in your company and organize and plan your business. Employee Tracker is here to help you keep everything organized and updated. The ability to find what you're looking for is right at your fingertips, all in one simple command prompt application.
This application was built using:
- JavaScript
- Node/NPM
- Inquirer
- SQL
- MySQL2
- Copy Link: Hit the "Code" button within this GitHub repo to copy link.
- Clone: Use the command "git clone paste link here".
- NPM: Run the command "npm install" to install Node Package Manager and the following dependencies from the package.json file:
- inquirer
- MySQL2
- console.table
- MySql:
- In integrated terminal, use "mysql -u username -p"
- Enter your MySQL password to login
- Download database and tables to your remote workspace from the 'db' folder using commands:
- 'source db/db.sql'
- 'source db/schema.sql'
- 'source db/seeds.sql'
After following installation instructions, navigate to your integrated terminal and begin the prompt using the command 'npm start' or 'node index.js.'
From the main menu, select your desired option:
- View all departments
- View all roles
- View all employees by manager
- View all employees by department
- View utilized budget by department
- Add a department
- Add a role
- Add an employee
- Update an employee role
- Remove a department
- Remove a role
- Remove an employee
Follow the prompts to add, update, or remove if chosen or simply select from the view list to access your tables.
Each selection, once completed, will bring you back to the main menu. To finish your session, simply close the terminal.
Would you like to see the Employee Tracker in action?
Watch this demo.
Have questions about this project?
GitHub: https://github.com/sarawrmas
Email: [email protected]
Sara Adamski