I am working on a project for Database management course. Currently I am working on Zillow.com So far I have found the entities and their attributes. Entities and their Attributes

$1.$ USER

$$ User$\_$ID $($PK$)$

$$ First Name

$$ Last Name

$$ Phone Number

$$ Email Address

$$ Account Creation Date

$$ User is Buyer

$$ User is Seller

$$ User is Renter

$$ User is Agent

$2.$ BUYER

$$ User$\_$ID $($PK$,$ FK$1)$

$$ Pre$-$Approval Status

$$ Contact Agent Status $($Whether they have contacted an agent$)$

$$ Loan Application Status

$3.$ RENTER

$$ User$\_$ID $($PK$,$ FK$1)$

$$ Application Status

$$ Lease Approval Date

$4.$ SELLER

$$ User$\_$ID $($PK$,$ FK$1)$

$$ Listing Status

$$ Property Valuation

$$ Agent Assigned ID

$$ Sale Date

$5.$ AGENT

$$ User$\_$ID $($PK$,$ FK$1)$

$$ License Number

$$ Agency

$$ Transaction Count

$$ Listing Count

$$ Rating

$$ Service Area

$6.$ PROPERTY

$$ Property$\_$ID $($PK$)$

$$ Prperty Type $($House$,$ Apartments$/$Condos$/$Co$-$ops, Townhomes, etc$)$

$$ Price $($Sale or Rent Price$)$

$$ Number of Bedrooms

$$ Number of Bathrooms

$$ Square Feet

$$ Lot Size $($Sqft or Acre$)$

$$ Zestimate $($Zillow$$s estimated Property Value$)$

$$ Other Amenities

$$ Location

$$ i$.$ Address

$$ ii$.$ City

$$ iii.$$ State

$$ iv$.$ Zip code

$7.$ LISTING

$$ Listing$\_$ID $($PK$)$

$$ Listing Price

$$ Listing Type $($For Sale, For Rent, Sold$)$

$$ Listing Date

$$ Listing Status $($Active$,$ Pending, Sold$/$Leased$)$

$$ Favorites $($Yes or No$)$

$8.$ TRANSACTION

$$ Transaction ID $($PK$)$

$$ Transaction Amount

$$ Transaction Date

$9.$ LOAN

$$ Loan$\_$ID $($PK$)$

$$ Loan Amount

$$ Interest Rate

$$ Loan Status

$$ Lender Name

$$ Repayment Terms

$10.$ REVIEW

$$ Review$\_$ID $($PK$)$

$$ Rating

$$ Review Comments

$$ Review Date

$$

$$

$$

$$

$$

$$

$$

$$Now I need your help to solve this questions. Can you help?

$1.$ Describe Your Approach to Achieving a Fully Normalized Logical Model $($with assumptions and tradeoffs that may exist$).$ Are there redundant tables and $1$:$1$ relationships that can be eliminated? Describe partial and transitive dependencies you encountered as you took your model from $1$NF to $2$NF to $3$NF$.$

$$

$2.$ Create a Data Dictionary

$$

Identify $10$ Business$/$User Views and Implement Using Query and Reports $($Produce Samples$).$ Select $2-3$ transaction inputs to populate your logical model tables and test against your physical model