Question: Define an ERD for the following narrative. The database should track homes and owners. A home has a unique home identifier, a street address, a

Define an ERD for the following narrative. The database should track homes and owners. A home has a unique home identifier, a street address, a city, a state, a zip, a number of bedrooms, a number of bathrooms, and square feet. A home is either owner-occupied or rented. An owner has a social security number, a name, an optional spouse name, a profession, and an optional spouse profession. An owner can possess one or more homes. Each home has only one owner. Agents represent owners in the sale of a home. An agent can list many homes but only one agent can list a home. An agent has a unique agent identifier, a name, a office identifier, and a phone number. When an owner agrees to list a home with an agent, a commission (percentage of the sales price) and selling price are determined
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
