Please answering the following questions, thanks.

1. 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. 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 requirenents. Consider the following ER diagram. Hint: Do not forget to add UNIQUE and NOT NULL in the schema where they needed. (50 pts) Note: For simplicity, the domain for each attribute can be omitted in the schema. The database schema should use the following format for each table Relation name (attribute name list), PK:, FK (if any): references UNIQUE, NOT NULL For example 2. Map it into a relational database schema