Question: Problem #3: Draw an ER diagram to model the application with the following assumptions. Specify key attributes of each entity type and (min, max) constraints

Problem #3: Draw an ER diagram to model the application with the following assumptions. Specify key attributes of each entity type and (min, max) constraints on each relationship type. . Each home uniquely defined by home identifier, street address, city, state, a number of bedrooms and a number of bathrooms and an associated owner. Each owner has a Social Security Number, first name, last name, phone, and profession. An owner can have one or more homes. 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 number, name, phone number and an associated office. When an owner agrees to list a home with an agent, a commission and a 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
