how to write this whole program using NetBeans program:

Sharaf DG is one of the leading Laptop dealers in Sultanate of Oman. You have been asked to develop an

interactive system $($Non$-$Graphical User Interface$)$ for the Sharaf DG to calculate the monthly commission.

The sales unit of Sharaf DG has decided to intensify its efforts to sell its most affordable laptop brand,

priced at $90$ OMR. To ensure the entire sales team is exerting the necessary effort, the sales unit has

introduced a commission$-$based reward system to recognize top$-$performing sales employees monthly. To

streamline the implementation of this commission system, the sales unit has requested an application

that can automatically calculate the monthly commissions.

$`$

IN SEMESTER $($INDIVIDUAL$)$ ASSIGNMENT

Module Code: COMP $20014\mathrm{.}1$ Module Name: Advanced Programming

Level: $2$ Max. Marks: $100$

Advanced Programming $($COMP $20014\mathrm{.}1)$ FALL $24$ CW$3($ASSMGT$)$ All $$ QP

MEC$\_$AMO$\_$TEM$\_035\_04$ Page $2$ of $16$

Based on the sales profit $($calculated by multiplying the number of items sold by the unit price$),$ the

program will apply the appropriate charge rate to determine the commission and then display the result.

The commission should be calculated using the following criteria:

$$ If the sales profit exceeds $20000,$ the commission is calculated using Charge Rate $1,$ which is $10\%.$

$$ If the sales profit is more than $10000,$ the commission is calculated using Charge Rate $2,$ which is

$5\%.$

$$ Otherwise use charge rate$3$ which is $0\%$

Note that charge rate$1,$ charge rate$2$ and charge rate$3$ are stored in a database.

On the client side, allow the user to enter the Sales Representative ID and number of Laptops sold. The

client will then forward the number of Laptops sold to the server.

Upon receiving the number of Laptops sold from the client, the server will calculate the sales profit of

that Sales Representative and then determine which charge rate to use to calculate the commission.

Then the server will calculate the commission and return to the client the sales profit, the commission

rate used, and the commission value calculated.

Develop an application using multithreading, client$-$server, networking, database and utility class concepts

as specify below

Task $1$ Database

Create a small database with a table having the fields: Charge Code and Charge Rate to hold the $3$ charge

rates given above. Use appropriate data type and field properties. Insert at least five records. Provide

screenshot$($s$)$ of the process of creating the database including the database server role together with

explanations of the steps taken to complete the task.

Task $2.$ Client$-$Side Program $(25$ marks$)$

Implement the client$-$side requirements $($non$-$graphical user interface$)$ and then provide code snippets for

each function with clear explanations$/$comments of key statements used.

The client$-$side would accept the Sales Representative ID and the number of Laptops sold. The client will

then forward the data to the server. $($Include input field validation wherever possible$).$

i$.$ Create a thread using extending thread class or implementing a runnable interface and implement

a run method.

ii$.$ Request connection to the server.

iii. Accept and forward the necessary data to the server.

iv$.$ Receive and display the results from the server.

v$.$ Close the connection after use.

vi$.$ Create a main class, instantiate a Thread object, and start the Thread.

Task $3.$ Server$-$side program

Implement the server$-$side requirements and then provide code snippets for each function with clear

explanations$/$comments of key statements used.

i$.$ Create a thread using extending thread class or implementing a runnable interface and implement

a run method.

ii$.$ After receiving the number of Laptops sold from the client side, the server should calculate the

sales profit and determine which charge rate to use

iii. Make connection to the database

iv$.$ Search the database using the charge code determined and retrieve the appropriate charge rate

v$.$ Use the retrieved charge rate to calculate the commission

vi$.$ Return to the client the sales profit calculated, the commission rate used, and the commission

value calculated

vii. Close the connection with the database when done

viii. Create a main class, instantiate a Thread object, and start the Thread

Task $4.$ Utility Class

Develop a Menu$-$Driven program of any utility class using the scenario given above and perform the

following operations.

i$.$ Create an object of the utility class based on the scenario with explanations of the method used.

ii$.$ Add an element to specified index of Java utility class based on the scenario with explanations of

the method used.

iii. Search for an element based on the scenario with explanations of the method used. Display the

element if found or an error message if the element does not exist.