Draw below an erd for the given business scenario. The type of relationship must be drawn for all relationships Our business is real estate.There are 3 players we keep data on the seller, the buyer, and the real estate agent.each has a first name, last name, email, and phone number.Both the seller and the buyer are uniquely identified by their social security number.For the agent, we also keep a record of what company they work for( eg. RE/max)Each agent is identified by their unique realtor numberan agent interacts with many sellers and many different buyersa seller also interacts with many different agents, but a buyer only ever interacts with one agent.A seller and buyer never meet, they only know of each other through the agent

Answered: Draw below an erd for the given…

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

Related questions

Question

Draw below an erd for the given business scenario. The type of relationship must be drawn for all relationships

Our business is real estate.
There are 3 players we keep data on the seller, the buyer, and the real estate agent.
each has a first name, last name, email, and phone number.
Both the seller and the buyer are uniquely identified by their social security number.
For the agent, we also keep a record of what company they work for( eg. RE/max)
Each agent is identified by their unique realtor number
an agent interacts with many sellers and many different buyers
a seller also interacts with many different agents, but a buyer only ever interacts with one agent.
A seller and buyer never meet, they only know of each other through the agent

Expert Solution