dBforums - View Single Post

FelipeJ · #3 (**permalink**) 05-12-03, 11:18

How nice of you!
It's just what i needed, thankyou very much.

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

thanks again,
Felipe Jaramillo

Quote:

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.

Is there another or easier way to do this?

Regards,
Felipe