Question $26(100$ points$)$

Big Realty Company $($BRC$)$ tries to match buyers with properties and wants to see

you create a crow's foot notation ERD for one small portion of their company. There

are many agents that work for BRC$.$ Agents work with buyers to find properties. Each

agent has an identifying agent number, which is kept along with the agent's name.

Agents have a specialty that is either "commercial" or "residential". Commercial

agents are most knowledgeable about commercial properties, like storefront

buildings, strip malls, and retail spaces. Residential agents are most knowledgeable

about residential properties like single$-$family homes, condos, and duplexes.

For an agent to work with a buyer, there must be an agreement between the agent

and the buyer$($s$).$ An agreement is a formal document that specifies that the buyer is

working exclusively with the specified agent. There must be an agreement document

in place before any work can be done for the buyer. This is true regardless of if the

buyer is interested in commercial properties or residential properties. Every

agreement is given a unique number. The date the agreement goes into effect, the

duration of the agreement $(90$ days is the most common duration$),$ and the percent

commission the agent will receive if the buyer decides on a property during the time

of the agreement. Active agents will typically have multiple active agreements, but

new agents may not have any agreements. Each agreement is a contract with one

and only one agent.

Each buyer is assigned a number in the system. The buyer's name and cell phone

number are recorded. A buyer can have only one active agreement in the system, but

over time, the buyer may work with many different agents, and any expired

agreements should be kept in the system too. Since it is common for multiple buyers

to work together $($couples buying a house, or an investment group buying commercial

property$),$ a single agreement can involve many buyers. Each buyer on the agreement

is considered a party to the agreement. Every agreement must have at least one

buyer that is a party of the agreement. To be in the system, a buyer must be a party

in at least one agreement. Create an crows foot notation ERD diagram