Normalize the following table 

 

Listing Agent 123 Main Street John Smith Broker Jane Doe Eve Carpenter Henry Smith Susan Kim 456 Elm Street Bob Jones 789 Oak Street Carol Jeffers Frank William Irene Brow Lily Smith Buyer Seller Susan Jones Michael Brown Identify the relationships between the tables. Normalize the database tables to the 4th normal form. Property Address House Image 1 123 Main Stree house1 Image 2 house2 Image3 Image4 Apartment 456 Elm Street apartment1 apartment2 apartment3 apartment4 789 Oak Street studio1 Studio