$--$ 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$)$

$)$; TASK: Create GUI

Management of IT Gear Dealer require an external program that will provide a graphical user

interface to display the results for the following stored procedures and functions you have

created:

$$ sp$\_$customer$\_$details

$$ func$\_$IT$\_$Gear

At this moment, you are not required to link the GUI to the database. You are allowed to use

any programming language and integrated development environment to achieve this

functionality.