Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions