Development Team:
Jacquelyn McCray
Michelle Jimenez
Joe Snyder
Kevin Sadler
- Clone the repository
- Run the SQL file "BangazonWorkforceData.sql" which will create and populate your database
- You're ready to run the program
Bangazon Workforce Management is an internal application for human resources and IT departments. The application allows them to manage Employees, Training Programs, Departments, and Computers.
The home page includes a bar chart that displays each employee in a given department and shows the number of training programs that employee is enrolled in.
HR has the ability to perform the following actions
- Add a new employee to the database
- Specify if employee is a supervisor
- Edit employee's information
- Assign an employee to a training program that is not at maximum capacity
- Assign/Unassign a computer to an employee
HR has the ability to perform the following actions
- Add a new department to the database
- Edit department's information
- View department's employees sorted by first or last name
- Remove departments that do not have employees
IT has the ability to perform the following actions
- Add a new computer to the database
- Assign/Unassign a computer to an employee
- View employee currently assigned to the computer
- Filter through computers based on make or manufacturer
- Remove a computer from the database that has never been assigned
HR has the ability to perform the following actions
- Schedule a new training program
- Edit program details
- Filter training programs by upcoming or completed
- View details of a training program including a list of attendees
- Remove upcoming programs from database