+ ERD Mid-Term Exam Practice ITD256 Draw below an ERD for the given business scenario. The type of relationship must be drawn for all relationships, but you do not need to show the minimum cardinalities Our business is real estate There are three 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 record of what company they work for (e.g.RE/MAX Century 21, etc.) 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 Remember with ERDs you don't need foreign keys