Consider the following data requirements. (50 pts)

A real estate agent has a license number, a name (first name and last name) and several phone numbers. Every agent must belong to a real estate company. A real estate agent can be a supervisor of several other agents, while an agent can only have one supervisor.

A real estate company has a company name and the number of real estate agents who work for the company.

A real estate company may have a number of real estate agents, while a real estate agent can only work for one real estate company.

A real estate company can have at most one parent real estate company. A real estate company can be the parent of several other real estate companies.

A house can be listed by only one real estate company. A house has a list id assigned by the real estate company. The list id is unique only within the same real estate company. A house also has the number of bed rooms and the square footage. A real estate company may list many houses at the same time.

A house buyer has an SSN and a birth date. The buyer may look at several houses, while a house may be seen by many buyers.

A buyer buys a house from a real estate agent on a closing date.

Draw an ER diagram based on the requirements.