Part $2$: Database Questions

The RRE Trucking Company database includes the three tables in Figure $8\mathrm{.}12.$ Use Figure $8\mathrm{.}12$ to answer questions $1$ to $4.$ Upload your answers to the assignment dropbox Module $2-$Learning Objective $2-$Assessment

TRUCK

$\backslash$table$[[$TNUM$,$BASENUM,TYPENUM,TMILES,TBOUGHT,TSERIAL$],[1001,501,1,5900\mathrm{.}2,\frac{11}{08}\frac{?}{90},$aa$-125],[1002,502,2,64523\mathrm{.}9,\frac{11}{08}\frac{?}{90},$ac$-213],[1003,501,2,32116\mathrm{.}0,\frac{09}{29}\frac{?}{91},$ac$-215],[1004,,2,3256\mathrm{.}9,\frac{01}{14}\frac{?}{92},$ac$-315]]$

BASE

$\backslash$table$[[$BASENUM$,$BASECITY,BASESTATE,BASEPHON,BASEMGR$],[501,$Dallas,TX$,893-9870,$J$.$ Jones$],[502,$New York,NY$,234-7689,$K$.$ Lee$]]$

TYPE

$\backslash$table$[[$TYPENUM$,$TYPEDESC$],[1,$single box, double axle$],[2,$tandem trailer, single axle$]]$

Figure $8\mathrm{.}12.$ Truck, Base and Type tables for question, by A$.$ Watt.

Identify the primary and foreign key$($s$)$ for each table.

What kind of relationship exists between the TRUCK and BASE tables?

What type of relationship exists between the TRUCK and the TYPE tables?

How many entities does the TRUCK table contain?