Decompose the RealEstate relation into $3$NF relations if it is not in $3$NF already. Merge relations

with a common primary key and remove any redundant subset relations. Check if the merged

relations are in $3$NF$,$ and apply further decomposition if needed until all final relations are in $3$NF$.$

Write down the final relational database schema and indicate the primary key $($underlined$)$ and

foreign key$($s$)($with an asterisk$*)$ in each relation.