If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

real estad DB design

Im from Colombia and my local programmer left me and a big proyect fell on top of me.

We are designing a real estate aplication in Mysql/php

There can be different types of real estate: appartments, houses, shops, fields, etc

All of them have some common data, like an unique code, an owner, description, yet, each has a lot of individual data, for example a shop needs to have the shopping mall its in, a field should include its size in hectares and its neighbours, an appartment should have the name of the building and say if it has parking, etc.

What im thinking is:

Make a table with the basic info for all items.

Make one table for each specific real estate type (shop, house, apartment, etc) with a code linking to the basic table.

What i guess is that i would have to make grid, add and update pages for each type of real estate.

Re: real estad DB design

>Im from Colombia and my local programmer left me and a big proyect >fell on top of me.
>We are designing a real estate aplication in Mysql/php
>There can be different types of real estate: appartments, houses, >shops, fields, etc

Re: real estad DB design

I will analyze both models but i guess the normalized model is more 'neat.

thanks again,
Felipe Jaramillo

Originally posted by FelipeJ
Hello,
Im glad ive found this forum.

Im from Colombia and my local programmer left me and a big proyect fell on top of me.

We are designing a real estate aplication in Mysql/php

There can be different types of real estate: appartments, houses, shops, fields, etc

All of them have some common data, like an unique code, an owner, description, yet, each has a lot of individual data, for example a shop needs to have the shopping mall its in, a field should include its size in hectares and its neighbours, an appartment should have the name of the building and say if it has parking, etc.

What im thinking is:

Make a table with the basic info for all items.

Make one table for each specific real estate type (shop, house, apartment, etc) with a code linking to the basic table.

What i guess is that i would have to make grid, add and update pages for each type of real estate.

Real Esate Database Design

Hello,
I need to design a database for a Real Estate Company which actually sells properties in all kinds (Lands, Villas, Houses, Farms, Compounds, Fields, etc.)
Usually the property can be a parent of another property. For example an apartment/flat is located in a compound/complex.

The apartment can be sold alone as well as the complex.

Each Property has a certain set of features. For example, No of Rooms. But this feature only applies to Apts/flats, villas, duplexes but not to a compound or to a field.

How can I store these features.

I know the above is confusing but I am really stuck and dont know where go. I have started something but not sure if I am on the right track.