Question $1$:

A real estate firm lists properties for sale. The firm has a number of sales offices in several states. For each office, it is important to know the location and

ength of time the office has been open. Each sales office has several employees. The company wants to track employee names, addresses, and

office. An employee can only manage the office to which he or she is assigned.

Attributes of each property for sale include the property number, location $($address$,$ city, state, and zip code$),$ and listing date. Each unit of property must

be listed with one $($and only one$)$ of the sales offices and sales offices each generally have multiple listings. Each property has one or more owners. For

each owner, we need to know the owner's name, address, and email address. An owner can own multiple properties and some properties have join ownership $($multiple owners$).$ Given this, it is important to know how much of each property is owned by each owner. Draw an ERD that models these dat

requirements.

Question $2$:

A nonprofit organization depends on a number of people for its successful operation. The organization must track, for each person, name, address, and

phone number. People can be classified into three categories: employees, volunteers, and donors. Each person can be in multiple categories $($e$.$g$.,$ a

volunteer the organization tracks which skills the volunteer possesses $($e$.$g$.,$ accounting, sales, lion taming$)$ and what level of proficiency the voluntee

what it is and that skill $($on a scale from $1$ to $10).$ Donors donate items $($including money$)$ to the nonprofit organization. For each item, we need to know

Assumption:

a$)$ Do we treat each donated item as a unique donation or can multiole donors donate the "same" item?

Assumption:

a$)$ Do we treat each donated item as a unique donation or can multiple donors donate the "same" item?

Question $3$: