Make ERD and GRD a courier moving company. the relationships of the project are as under.

Customer $($customer$\_$id$\{$P$.$K$\},$ First$\_$name, Last$\_$name, Contact, Address, Email$)$

Driver $($Driver$\_$id $\{$P$.$K$\},$ First$\_$name, Last$\_$name, Contact, Address, Rating, Vehicle$\_$type$)$

Active$\_$Job $($Job$\_$id $\{$P$.$K$\},$ Customer$\_$id$\{$F$.$K$\},$ Pick$\_$up$,$ Drop$\_$off, Vehicle$\_$preference$)$

Bidding $($Bid$\_$id$\{$P$.$K$\},$ Job$\_$id$\{$F$.$K$\},$ Driver$\_$id$\{$F$.$K$\},$ Fare, Status$)$

Assigned$\_$Job $($Job$\_$id$\{$F$.$K$\},$ Driver$\_$id$\{$F$.$K$\})$

Past$\_$trip $($Job$\_$id$\{$F$.$K$\},$ Status, Time$\_$appointed, Time completed$)$

First $2$ Tables are basic. Active job is posted by the user with cutomer id a foreign key. user sets the vehicle preference from truck, UTE, Car, Bike, Van. from BIDDING table only those driver bid whose Vehicle$\_$type $($Driver table$)=$ Vehicle$\_$preference$($Active$\_$Job$).$ Status in bidding table is weather the customer accepts the big or not.

Assigned$\_$job table has Job$\_$id and Driver Id both as foreign Key and job is assigned to the driver whose Status $($bidding$\_$table$)=$ Accepted.

Past$\_$trip stores history of the trip. it saves the time started of a trip and time completed. and status weather it is completed or cancelled.

ERD should look something like the sample picture as under.