Prepare an ERD for the Garden Real Estate Firm that lists property for sale. The following

describes this organization:

$$ The firm has a number of sales offices in several states. Attributes of sales office include

Office Number $($identifier$)$ and Location.

$$ Each sales office is assigned one or more employees. Attributes of employee include

Employee ID $($identifier$)$ and Employee Name. An employee must be assigned to only one

sales office.

$$ For each sales office, there is always one employee assigned to manage that office. An

employee may manage only the sales office to which he or she is assigned.

$$ The firm lists property for sale. Attributes of property include Property ID $($identifier$)$ and

Location. Components of Location include Address, City, State, and Zip Code.

$$ Each unit of property must be listed with one $($and only one$)$ of the sales offices. A sales

office may have any number of properties listed or may have no properties listed.

Complete an ER Diagram for this scenario. Thanks!