Part $1.$ Keys $(10$ pts$)$

Use the database shown below to answer the following questions:

TYPE

Question $1\mathrm{.}1(2$ pts$)$

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

Question $1\mathrm{.}2(2$ pts$)$

Does the TRUCK table exhibit entity and referential integrity? Why or why not?

Question $1\mathrm{.}3(2$ pts$)$

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

Question $1\mathrm{.}4(2$ pts$)$

How many entities does the TRUCK table contain?

Question $1\mathrm{.}5(2$ pts$)$

Identify the TRUCK table candidate key$($s$).$