NOTE: FOR E R DIAGRAM either draw on paper OR in a visio just make it readable and clear $!!!$

AND NO AI PLease!

Give an E$-$R Model for the following narrative given by a manager of a fictional real estate company:

$$Our database keeps track of houses and sellers. Each house has a unique home ID$,$ a location $($consisting of a street address and a state name$),$ and a number of square feet. A seller has a Social Security number to identify him$/$her$,$ a name, a phone number, and an optional spouse name. A seller may own one or more houses, but each house has just one seller that owns it$.$

$$Our agents list houses for the sellers $$ a seller may use the same agent to list many of their houses if they have several houses to sell, or they may list different houses with different agents. An agent can list many houses, of course, but each house is only listed by one agent at a time. Each agent has a unique AgentID, a name, one or more phone numbers, and a name for the office out of which he$/$she works. When a seller lists a house with an agent, an asking price and a commission percentage are determined.$$

$$We keep track of potential buyers too. A buyer has a Social Security number to identify him$/$her$,$ a name, a phone number, and a price range $($consisting of lower and upper limits$).$ An agent can represent many buyers, but a buyer is represented by only one agent $$ in fact, we don$$t even keep track of the information on a potential buyer unless he$/$she is represented by one of our agents.

Also provide a formal written description of your E$-$R Model, with all of the necessary information for each entity, attribute, and relationship. After your formal written description, include a list of $$Additional Assumptions$$ that you had to make beyond what was stated in the narrative to determine the properties of the entities, attributes, and relationships