$--$ Create the Stock table

CREATE TABLE Stock $($

Stock$\_$ID NUMBER PRIMARY KEY,

Stock$\_$Type VARCHAR$2(50)$ NOT NULL,

Stock$\_$Model VARCHAR$2(50)$ NOT NULL,

Manufacturer VARCHAR$2(50)$ NOT NULL

$)$;

$--$ Create the Customer table

CREATE TABLE Customer $($

Cust$\_$ID VARCHAR$2(10)$ PRIMARY KEY,

Cust$\_$FName VARCHAR$2(50)$ NOT NULL,

Cust$\_$SName VARCHAR$2(50)$ NOT NULL,

Cust$\_$Address VARCHAR$2(100)$ NOT NULL,

Cust$\_$Contact VARCHAR$2(20)$ NOT NULL

$)$;

$--$ Create the Repairs table

CREATE TABLE Repairs $($

Repair$\_$ID NUMBER PRIMARY KEY,

Repair$\_$Work VARCHAR$2(100)$ NOT NULL,

Repair$\_$Date DATE NOT NULL,

Repair$\_$Hours NUMBER NOT NULL

$)$;

$--$ Create the Sales table

CREATE TABLE Sales $($

Sales$\_$Num NUMBER PRIMARY KEY,

Sales$\_$Date DATE NOT NULL,

Sales$\_$Amt NUMBER NOT NULL,

Stock$\_$ID NUMBER,

Cust$\_$ID VARCHAR$2(10),$

Repair$\_$ID NUMBER,

FOREIGN KEY $($Stock$\_$ID$)$ REFERENCES Stock$($Stock$\_$ID$),$

FOREIGN KEY $($Cust$\_$ID$)$ REFERENCES Customer$($Cust$\_$ID$),$

FOREIGN KEY $($Repair$\_$ID$)$ REFERENCES Repairs$($Repair$\_$ID$)$

$)$;

Question

$(15$ Marks$)$

TASK: Create Function

Create a function called fn$\_$IT$\_$Gear that would be meaningful and relevant for this

database. Your function should accept at least $1$ input parameter and display at least $4$

relevant pieces of information.

In your solution,

$$ display the data and provide the code to execute the function.

$$ use relevant exception handling and

$$ provide relevant code comments $.$