RE: Database Design questions

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 18 Jun 2004 12:15:24 -0700
Message-ID: <B5C5F99D765BB744B54FFDF35F60262109F87908@irvmbxw02>

I would try and read up about database normalization from a theoretical standpoint.
E.g. here's a sample article
http://databases.about.com/library/weekly/aa080501a.htm At the bottom of the page there are links to several related articles.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Pallav Kalva Sent: vendredi, 18. juin 2004 11:15
To: oracle-l_at_freelists.org
Subject: Re: Database Design questions

I have been replying to messages but somehow may message doesnt go to the list, hope this one makes it.

Thanks! for all your comments. I think , I should explain more about my application, the table which I showed is
the data from one company for one type of property listing say "Preforeclosure" data. I will be having similar types of tables for different types of property listings like "foreclosures" ,
"Foresalebyowner" and from different companies. In that case I will end up with 10-20 tables each with 130 columnns.=20

Does it make sense to break the data into several tables and have one-to-one relationsips ? There would be some updates to the properties otherwise it is mostly showing property listings on our website.=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Fri Jun 18 2004 - 14:14:16 CDT