Given the following relation, LOT, normalize the relation, and all subsequent relations through 3NF. Be sure to indicate primary keys and foreign keys. You need to provide reference statements for foreign keys. Be sure to re-write LOT as it finally stands.

LOT(PropertyID#, CountyName, Lot#, Area, Price, TaxRate)

Functional Dependencies:

PropertyID# ⇒ CountyName, Lot#, Area, Price, TaxRate (Functional dependency 1)

CountyName, Lot# ⇒ PropertyID# , Area, Price, TaxRate (Functional dependency 2)

CountyName ⇒ TaxRate (Functional dependency 3)

Area ⇒ Price (Functional dependency 4)

Write your answer in Relational Schema Format.