Question: EER diagram help HOMESALES database description For this database we need to store information for home sales here in Atlanta. The database needs to store

EER diagram help

EER diagram help HOMESALES database description For this database we need to

HOMESALES database description For this database we need to store information for home sales here in Atlanta. The database needs to store information about homes (HOME) that may or may not be on the market, and people (PERSON) some of which are real estate agents (REALTOR) and some of which are not real estate agents (CLIENT). All people have unique names that are made up of both a first name and a last name, and multiple email addresses that are not unique. Real estate agents also have unique CID numbers and the ability to find out the number of homes they currently have on the market. At any one time, the real estate agent may be advertising several homes. Both real estate agents and clients may own homes, but if so, they can only own one. Each home has a number of rooms, a price in Dollars, and a unique address. If the person owns a home they have an associated date in which they acquired that home. If a home is on the market, it will have to have a single real estate agent advertising it

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!