Thanks for the information. The thumb rule and all will definitely help me in modelling.
Thanks a Lot
Best Regards
B S Pradhan
----------------------------------------
On Wed, 22 Oct 2003 Michael Milligan wrote :
>Hi Again,
>
>What I do when a model is going to change is try to make it as flexible as
>possible from the start. Build more abstraction into the model than you
>normally would. Normalization is even more important here, even going to 4th
>or 5th form, or at least Boyce-Codd 3rd. You want to design it so that when
>someone wants to change the structure, it may be facilitated by the addition
>of a new record instead of a new column. A very simplistic example would be
>to have a separate address entity allowing for the possibility of multiple
>addresses per customer, instead of building the address attributes right
>into the customer entity. A good rule of thumb: whatever will change should
>be changeable by addition or subtraction of a row. Whatever won't change is
>a candidate for a column. That's a generalization, but a good rule
>nonetheless.
>
>Data Architect from Sybase, ER/Studio from Embarcadero, Erwin from Computer
>Associates are all good tools and easy to learn. QDesigner is the Data
>Architect physical modeler repackaged by Quest and sold for less. Excellent
>tool.
>
>Michael
>
>
>This e-mail, including attachments, may include confidential and/or
>proprietary information, and may be used only by the person or entity to
>which it is addressed. If the reader of this e-mail is not the intended
>recipient or his or her authorized agent, the reader is hereby notified that
>any dissemination, distribution or copying of this e-mail is prohibited. If
>you have received this e-mail in error, please notify the sender by replying
>to this message and delete this e-mail immediately.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Michael Milligan
> INET: Michael.Milligan@ingenix.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: bhabani s pradhan
INET: bhabaniindia_at_rediffmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Oct 22 2003 - 07:59:26 CDT
