Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2011
    Posts
    2

    Cool Unanswered: Robust Database for Real Estate Website

    I need to make a Real Estate Project, where user can post different listings for Sale or Rent their Real Estate Properties.
    There are some Catagories for Properties with different Properties types.
    for example
    1. Resedential
    home
    portion
    flat
    apartment
    2.Commercial
    shop
    office
    floor
    etc.

    Now the problem is that every property type has some common attribute i.e price, Area, construction but also has some uncommon attributes like home doesn't contain parking attribute while a shop or office has.

    Please if anybody can tell me how to structure this as a database.

    Thanks,
    With Regards,
    Shairoo

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    this is a classic supertype/subtype problem

    you need a supertype table called properties, which will hold all the common columns

    then you need two subtype tables called residentialprops and commercialprops with only the unique columns (and of course a Foreign Key which references the Primary Key of the supertype table)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Mar 2011
    Posts
    2
    but there are also distint variables for every residential or commercial property type......

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    No there isn't, unless you are working with some seriously bizarre MLS vendor.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •