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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!