I have a database of a courier moving company. the mySql code for it is

CREATE TABLE Customer $($

customer$\_$id INT PRIMARY KEY,

first$\_$name VARCHAR$(50),$

last$\_$name VARCHAR$(50),$

contact VARCHAR$(20),$

address VARCHAR$(100),$

email VARCHAR$(100)$

$)$;

CREATE TABLE Driver $($

driver$\_$id INT PRIMARY KEY,

first$\_$name VARCHAR$(50),$

last$\_$name VARCHAR$(50),$

contact VARCHAR$(20),$

address VARCHAR$(100),$

rating FLOAT

$)$;

CREATE TABLE Job $($

job$\_$id INT PRIMARY KEY,

customer$\_$id INT,

pick$\_$up VARCHAR$(100),$

drop$\_$off VARCHAR$(100),$

vehicle$\_$preference VARCHAR$(50),$

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

$)$;

CREATE TABLE Bidding $($

bid$\_$id INT PRIMARY KEY,

job$\_$id INT,

driver$\_$id INT,

fare DECIMAL$(10,2),$

status VARCHAR$(20),$

FOREIGN KEY $($job$\_$id$)$ REFERENCES Job$($job$\_$id$),$

FOREIGN KEY $($driver$\_$id$)$ REFERENCES Driver$($driver$\_$id$)$

$)$;

CREATE TABLE Active$\_$Job $($

job$\_$id INT PRIMARY KEY,

FOREIGN KEY $($job$\_$id$)$ REFERENCES Job$($job$\_$id$)$

$)$;

CREATE TABLE Assigned$\_$Job $($

job$\_$id INT PRIMARY KEY,

driver$\_$id INT,

FOREIGN KEY $($job$\_$id$)$ REFERENCES Active$\_$Job$($job$\_$id$),$

FOREIGN KEY $($driver$\_$id$)$ REFERENCES Driver$($driver$\_$id$)$

$)$;

CREATE TABLE Past$\_$Trip $($

job$\_$id INT PRIMARY KEY,

status VARCHAR$(20),$

time$\_$appointed DATETIME,

time$\_$completed DATETIME,

FOREIGN KEY $($job$\_$id$)$ REFERENCES Active$\_$Job$($job$\_$id$)$

$)$;

according to the code, what would be the ERD of the database and GRD of the database. please give graphical representation of ERD and GRD$.$