Assume you are creating a database for RE/MAX Reality. Suppose you have created the ER diagram in the attached PDF file.
Attributes in Buyer: BID, BName, Address(street, city, state), Phone (multi-valued)
Attributes in Seller: BID, SName, Address(street, city, state), Phone (multi-valued)
Attributes in Agent: BID, BName, Address(street, city, state), Phone (multi-valued)
Attributes in House: HID, HAddress(street, city, state), square-footage, year, other-features(multi-valued)
Please convert the ER diagram into tables. Please specify tables, columns (you also need to specify primary key and foreign key columns).