draw an ERD diagram according to the given information for veteniery clinic below. CREATE TABLE Customers $($

customer$\_$id INT PRIMARY KEY,

name VARCHAR$(100),$

contact$\_$details VARCHAR$(255)$

$)$;

CREATE TABLE Pets $($

pet$\_$id INT PRIMARY KEY,

name VARCHAR$(100),$

date$\_$of$\_$birth DATE,

genre VARCHAR$(50),$

type VARCHAR$(50),$

special$\_$foods VARCHAR$(255),$

habitat VARCHAR$(255),$

care VARCHAR$(255),$

license$\_$number VARCHAR$(50),$

customer$\_$id INT,

FOREIGN KEY $($customer$\_$id$)$ REFERENCES Customers$($customer$\_$id$)$

$)$;

CREATE TABLE Vets $($

vet$\_$id INT PRIMARY KEY,

name VARCHAR$(100),$

specialization VARCHAR$(100)$

$)$;

CREATE TABLE Inspections $($

inspection$\_$id INT PRIMARY KEY,

pet$\_$id INT,

vet$\_$id INT,

date DATE,

findings TEXT,

FOREIGN KEY $($pet$\_$id$)$ REFERENCES Pets$($pet$\_$id$),$

FOREIGN KEY $($vet$\_$id$)$ REFERENCES Vets$($vet$\_$id$)$

$)$;

CREATE TABLE Treatments $($

treatment$\_$id INT PRIMARY KEY,

pet$\_$id INT,

vet$\_$id INT,

date DATE,

description TEXT,

FOREIGN KEY $($pet$\_$id$)$ REFERENCES Pets$($pet$\_$id$),$

FOREIGN KEY $($vet$\_$id$)$ REFERENCES Vets$($vet$\_$id$)$

$)$;

CREATE TABLE Staff $($

staff$\_$id INT PRIMARY KEY,

name VARCHAR$(100),$

role VARCHAR$(50)$

$)$;

CREATE TABLE PetSupplies $($

supply$\_$id INT PRIMARY KEY,

name VARCHAR$(100),$

description TEXT,

price DECIMAL$(10,2)$

$)$;

CREATE TABLE SalesRecords $($

sale$\_$id INT PRIMARY KEY,

customer$\_$id INT,

supply$\_$id INT,

date DATE,

quantity INT,

FOREIGN KEY $($customer$\_$id$)$ REFERENCES Customers$($customer$\_$id$),$

FOREIGN KEY $($supply$\_$id$)$ REFERENCES PetSupplies$($supply$\_$id$)$

$)$;