Question
Consider the following data requirements. A real estate agent has a license number, a name (first name and last name) and several phone numbers. Every
Consider the following data requirements.
A real estate agent has a license number, a name (first name and last name) and several phone numbers. Every agent must belong to a real estate company. A real estate agent can be a supervisor of several other agents, while an agent can only have one supervisor.
A real estate company has a company name and the number of real estate agents who work for the company.
A real estate company may have a number of real estate agents, while a real estate agent can only work for one real estate company.
A real estate company can have at most one parent real estate company. A real estate company can be the parent of several other real estate companies.
A house can be listed by only one real estate company. A house has a list id assigned by the real estate company. The list id is unique only within the same real estate company. A house also has the number of bed rooms and the square footage. A real estate company may list many houses at the same time.
A house buyer has an SSN and a birth date. The buyer may look at several houses, while a house may be seen by many buyers.
A buyer buys a house from a real estate agent on a closing date.
Draw an ER diagram based on the requirements.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started