Q$1.$ Create the ERD for this database.

You can create the ERD $($Entity$-$Relationship Diagram$)$ as follows:

Entities:

$$ TRUCK

$$ BASE

$$ TYPE

Relationships:

$$ The TRUCK table has a many$-$to$-$one relationship with both the BASE and TYPE tables via the foreign keys BASE$\_$CODE and TYPE$\_$CODE.

Q$2.$ Create the relational diagram for this database.

The relational diagram would look like this:

$$ TRUCK Table: Contains TRUCK$\_$NUM, BASE$\_$CODE, TYPE$\_$CODE, TRUCK$\_$MILES, TRUCK$\_$SERIAL$\_$NUM.

o BASE$\_$CODE references BASE$($BASE$\_$CODE$).$

o TYPE$\_$CODE references TYPE$($TYPE$\_$CODE$).$

$$ BASE Table: Contains BASE$\_$CODE, BASE$\_$CITY, BASE$\_$STATE, BASE$\_$AREA$\_$CODE, BASE$\_$PHONE, BASE$\_$MANAGER.

$$ TYPE Table: Contains TYPE$\_$CODE, TYPE$\_$DESCRIPTION.