QUESTION $2$

As a database analyst, you were asked to prepare an Entity Relationship diagram $($contain

all entity, relationship, attributes, keys etc.$)$ representing the requirements for a real estate

company. The following scenario describes the company.

The company has several sales offices in several locations. A location is described

by the office number $($key$),$ an address, and the number of agents at the location.

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

include Employee$\_$ID $($key$),$ and Employee$\_$Name. An employee must be assigned to only

one sales office.

The firm lists properties for sale. Attributes of a property include Property$\_$ID

$($identifier$)$ and Location. Components of Location include Address, City, State, and

Zip$\_$Code. In addition, we want to know the selling price of the property and the year it was

constructed.

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

and one and only one agent in the company. A sales office may have any number of

properties listed or may have no properties listed.

Each unit of the property has one or more owners. Associated with an owner is

Owner$\_$ID and Owner$\_$Name. An owner may own one or more units of property. A feature

of the relationship between property and owner is Percent$\_$Owned.