Your software development team has been asked to deliver a minimal working UX for a basic employee management system for company $\text{'}2\text{'}.$ The software design document will be a set of designs for this software system involving its data and programming schemas. They have NO GUI$/$UX for their needed system. They have one person putting the data into their database using Beaver and MySQL scripts.$$

They have less than twenty full$-$time employees.$$

They require several reports:$$

$1)$ Full$-$time employee information with pay statement history.$$

$2)$ Total pay for month by job title.$$

$3)$ Total pay for month by Division. $$

$$

They need simple features$/$functionality in the system to ensure they get some basic things like:$$

$1)$ Change employee table; add column SSN $($no dashes$).$

$2)$ Search for an employee using name, SSN$,$ empid to show their information.$$

$3)$Update an employee's data.$$

$4)$Update employee's salary for an increase of a particular percentage only for a salary amount range. E$.$G$.,3\mathrm{.}2\%$ for salary greater than, equal to $58$K but less than $105$K$.$

$5)$ There is NO need for any user logon$/$authorization functionality.$$

Question:

Create a code from the topic above with the following key concepts:

Test cases that ensure these features$/$functions are going to work and update data correctly:$$

Update employee data $($make it general enough using your new classes for all employee data$)$

Search for employee$$

Update salary for all employees less than a particular amount