Consider the relation schema LOTS shown in Table $3,$ which describes parcels of land

for sale in various counties of a state. Suppose that there are two candidate keys:

PropertyID and $\{$County$,$ LotNo$\}$; that is$,$ lot numbers are unique only within each

county, but PropertyID numbers are unique across counties for the entire state.

PropertyID is chosen as the primary key, and it is underlined in Table $3.$

Table $3$: LOTS relation

PropertyID County LotNo Area

$($Acre$)$

Price

$($USD$)$

TaxRate

P$00121$ Shawnee LN$020\mathrm{.}5500,0005\mathrm{.}5$

P$05155$ Lyon LN$021\mathrm{.}2800,0007\mathrm{.}5$

P$01215$ Shawnee LN$210\mathrm{.}5500,0005\mathrm{.}5$

P$20110$ Lyon LN$311\mathrm{.}41,000,0007\mathrm{.}5$

P$50551$ Shawnee LN$520\mathrm{.}6600,0005\mathrm{.}5$

P$11111$ Shawnee LN$310\mathrm{.}7700,0005\mathrm{.}5$

P$07123$ Lyon LN$251\mathrm{.}41,000,0007\mathrm{.}5$

$($i$)$ Identify all functional dependencies for relation LOTS.