Evaluate the tables separately in the following ERD. Below is the data dictionary for the entities and each attribute. Similar to Homework $1,$ state the highest normal form that the entity conforms to and if it's not in $4$NF$/5$NF$,$ state each violation of the next highest normal form.

LISTING $$ a table for storing data on the listings and sales of the houses.

PERSON $$ table for storing data on the people that buy and sell houses.

OWNS $$ table for storing data on which people are associated with a house either as a buyer $($becoming the new owner$)$ of a property or a seller $($the original owner$)$ of a property. Data on the sellers $($the original owners$)$ is necessary to create the listing. Data about buyers, if there are any, will be added later when the contract is created at the time of sale. The same person cannot buy and sell a house on the same day.

LISTING

ListingBeginDate $$ the date on which the listing begins.

HouseID $$ an identification number given to a house when it enters the system.

AgentNumber $$ the identification number assigned to the agent associated with the current listing.

Address $$ the address $($street$,$ city, state, and ZIP code$)$ of the house being placed for sale.

ListingEndDate $$ the date on which the listing ends.

YearBuilt $$ the year in which the house for sale was originally built.

OriginalAskingPrice $$ the price that the sellers are asking buyers to pay for the house at the beginning of the listing.

CurrentAskingPrice $$ the price that the sellers are currently asking buyers to pay for the house. While the asking price of the house may change many times during the listing, only the original asking price and the most current asking price need to be retained by the system.

ContractNumber $$ an identification number assigned to a contract if a house sells during a listing.

ContractDate $$ the date on which the contract for the sale of the house is signed by the buyers and sellers of the house if a house sells during a listing.

ActualSoldPrice $$ the dollar amount that the buyers and seller agree on for the sale of a house if a house sells during a listing.

SquareFeet $$ the size of the house expressed in square feet.

PERSON

SocialSecurityNumber $$ the social security number of the person that is either buying or selling a house. It is used as a unique identifier for each person.

FirstName $$ the first name of the buyer or seller.

LastName $$ the surname or family name of the buyer or seller.

Phone $$ the primary contact phone number for buyer or seller. While an individual may have many potential contact numbers, this system should only track the one and only one phone number that is their primary contact number.

QualifiedLoanAmount $$ the dollar amount that a buyer is pre$-$qualified for by a lending institution. If a person is a buyer then they may or may not present the agent with documentation of a qualified loan amount as proof of their earnest interest in the house for sale.

OWNS

ListingBeginDate $$ the date on which the current listing of the house by the owners began.

HouseID $$ an identification number given to the house being listed for sale.

SocialSecurityNumber $$ the social security number of the person that is either buying or selling a house.

Role $$ an indicator of whether the current individual is being entered as a "buyer" or "seller" of the house.