$--$ 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: Database Security Mini$-$ Presentation

$($Marks: $10)$

At the moment, the management requires a mini presentation on how you would achieve

data security. Provide at least five $(5)$ ways you would ensure database security, referring

to the case study in your answer.