Q$.$ Define the following. $(2$ pts$)$

Primary Key, Foreign Key

Q$.$ For this question, answer the below questions based upon figure P$3\mathrm{.}17($Total: $13$ pts$)$

Answer the following questions based upon figure P$3\mathrm{.}17$

$1.$ Does table TRUCK, BASE, TYPE have unique primary key defined? Yes$/$No$(1$ pt$)$

$2.$ List Primary key for tables TRUCK, BASE, TYPE $(3$ pts$)$

$3.$ List Foreign Key for each table. Write NA $($Not Applicable$)$ if the table does not have a foreign

key. $(3$ pts$)$

$4.$ Identify the TRUCK table$$s candidate key$($s$).(1$ pts$)$

Candidate key is like an alternative primary key so it has to be unique throughout the table.

$5.$ Create the Entity Relationship Diagram for this database. $(5$ pts$)$

You can draw this with hand and upload pic or use Word to draw it as we