Data Model ~ Real Estate...This data model was designed to handle Brokers, their Listings and Sellers attached to those Listings, as well as, the Buyers interested in the Listings. (Note, there only tables included in this database the balance is up to you!) To download the Data Model click here.

Business Rules...

Each Listing will have a Broker

Sellers may have more than one Listing

Rooms will vary in size

There will be Buyers

There will be multiple Listings

Listings will vary in Type...

Buyers may be interested in multiple Listings

There will be Sellers

Main Entities...

Listings

Buyers

Sellers

...be assigned specific Buyers

Buyers will work with Brokers

Buyers may be looking in specific Locations

Brokers

in Size and Levels

in Location

in amount of Rooms

Listings can have more than one interested Buyer

Listings Asking Price may change

Buyers will most likely be looking for specific Room Counts

Brokers will...

...be assigned specific Listings

The difficult I do immediately, the impossible takes a little bit longer.