Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-12-09 : 06:56:57
|
| Thomas Tran writes "Which is the better way to design the data table for property of the real estate listing? For example the listing contains more than properties, each property contains more than home features and community features. How can i design the database so that the home features can be extended without changing the database structure, e.g. the property can have home features like air-condition, car park and later on , we may be able to add new features to it such as Laundry Room, Fireplace.Thank you" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-12-09 : 06:59:53
|
| This might be worth looking into:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57307As long as you use this approach only for the variable data elements (pool, fireplace, garage) and not for required elements (bedrooms, bathrooms, square footage) it should work out quite well. |
 |
|
|
|
|
|
Real Estate database design