Write a PL$/$SQL block that will prompt for an employee# number ate runtime. The block will display the employee# and name, job description, salary and employee manager for all employee working in the same department number as the input employee, see sample output below:Question $1($Composition$)$:

Preparation:

Create a new NetBeans project called Question$1.$

In the extracted provided files, under folder Q$1,$ you will find the files needed for this question.

Add the provided Hand.jar file to the "Libraries" for Question$1$ project.

Remember to Edit the Hand library and add the extracted "javadoc" folder as the Javadoc for this library.

Create a new class called AnalogueWatch for the Question$1$ project and complete it as described below.

The questions:

An analog watch, also called an analogue watch, is a timepiece that displays the time using hands on a traditional clock face, as opposed to a digital display

that shows the time in numerals. The analog watch has different parts but the most important are the face and the $3$ hands.

The face is the front of the watch, where the hands and markings are located. It is usually made of glass or plastic and can be round, square, or other shapes.

The hands are the pointers that rotate around the face to indicate the time. There are typically three hands:

Hour hand: The shorter hand that points to the hour.

Minute hand: The longer hand that points to the minute.

Second hand: A very thin hand that sweeps around the face once every minute.

For this question, it is expected of you to create a concrete class called AnalogueWatch that represents an analogue watch. Follow the instructions in the

description table $($Table $1\mathrm{.}2)$ and the information given in the UML diagram $($Table $1\mathrm{.}1)$ and complete the AnalogueWatch class.,

Enter employee$\_$number: $7788$

EMPLOYEE JOB SAL MANAGER

$---------------------------------------------$

$1.7788-$SCOTT ANALYST $3000$ JONES

$2.7902-$FORD ANALYST $3000$ JONES

$3.7876-$ADAMS CLERK $1100$ SCOTT

$4.7566-$JONES MANAGER $2975$ KING

$5.7369-$SMITH CLERK $800$ FORD

No$.$ of staff: $5$

Total salary: R$10875$

$3\mathrm{.}4\mathrm{.}1$ Use BASIC loop with PL$/$SQL variables.

$3\mathrm{.}4\mathrm{.}2$ Use WHILE loop with PL$/$SQL record.

$3\mathrm{.}4\mathrm{.}3$ Use cursor$-$FOR loop

$3\mathrm{.}4\mathrm{.}4$ Use BASIC or WHILE loop with parameter $($the employee# should be treated as parameter to the cursor