$4\mathrm{.}3$ Q secondary key. $(9$pts$)$

$4\mathrm{.}4$ Send to expert

$4\mathrm{.}5$ Give me an example

$4\mathrm{.}6$ Study with flashcards

$4\mathrm{.}7$ Let$$s practice

You have $20$ expert questions left.

$4\mathrm{.}8$ What kind of relationship exists between the TRUCK and BASE tables? $\backslash$

$4\mathrm{.}9$ How many entities does the TRUCK table contain $?$

$4\mathrm{.}10$ Identify the TRUCK table candidate key$($s$).$

$$

$5.$ Suppose you are using the database in Figure $8\mathrm{.}13,$ composed of the two tables. Use Figure $8\mathrm{.}13$ to answer questions $5\mathrm{.}1$ to $5\mathrm{.}6.$

$5\mathrm{.}1$ Identify the primary key in each table.

$5\mathrm{.}2$ Identify the foreign key in the BookOrders table.

$5\mathrm{.}3$ Are there any candidate keys in either table?

$5\mathrm{.}4$ Draw the ER model.

$5\mathrm{.}5$ Does the BookOrders table exhibit referential integrity? Why or why not?

$5\mathrm{.}6$ Do the tables contain redundant data? If so which table$($s$)$ and what is the redundant data?

$$

Use the ERD of a school database in Figure $8\mathrm{.}15$ to answer questions $6$ to $9.$

$6.$ Identity all the kernels and dependent and characteristic ent