2023 Statement Create a C Windows application named EmployeeManagement and add a database named EmployeeData mdf The database should have | Assignment Collections

Statement Create a C# Windows application (named EmployeeManagement) and add a database named EmployeeData.mdf. 

The database should have a table named Employees, with columns for employee ID, name, position, and hourly pay rate. The employee ID should be the primary key. Insert at least five sample rows of data into the Employees table.

On the application’s main form (named MainForm), add a DataGridView to display the Employees table and also add a button that, when clicked, displays a second form. The second form (named EmployeeDataDetailsForm) should display the employee table in a Details view. Make sure that when the second form is closed, the main form refills the dataset so that the most current data is displayed.

Then, add the third form (named EmployeeDataSortingForm) that also displays the Employees table in a DataGridView control and also add the following two buttons on the third form. Make sure the third form is properly connected the main form by using a menu in a menu strip control.

A button that, when clicked, sorts the data in ascending order by hourly pay rate.

A button that, when clicked, sorts the data in descending order by hourly pare rate.

Add the fourth form (named EmployeeDataSearchForm) that also displays the Employees table in a DataGridView control and also connect this new form to the main form by using a menu.  This form should let the user specify a name in a text box and then search for that name in the Employee table. The DataGridView should display any rows that contain a full or partial match of the specified name.

Add the fifth form (named EmployeeDataAnalysisForm) that also displays the Employee table in a DataGridView control and also connect this new form to the main form by using a menu. Then add the following two buttons.

A button that, when clicked, displays on a label the highest (maximum) pay rate in the table.

A button that, when clicked, displays on a label the lowest (minimum) pay rate in the table.