EQuestion $3$:

Prepare an $E-R$ diagram for a real estate firm that lists property sale. The following describes the organization.

The firm has a number of sales offices in several states. Attributes of sales office include Office$\_$Number $($identifier$)$ and Location.

Page $1$ of $4$

Prince Sultan University

College of Computer and Information Sciences

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 sale office to which 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. relationship belween property and owner

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.

Each unit of property has one or more owners. Attributes of owner are Owner$\_$ID $($identifier$)$ and Owner$\_$Name. An owner may own one or more units of property. An attribute of the relationship between property and owner is Percent$\_$Owned.

relationship

attribute