Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Checking if a table is normalized using SQL

Re: Checking if a table is normalized using SQL

From: Thomas Kellerer <TAAXADSCBIXW_at_spammotel.com>
Date: Sun, 18 Mar 2007 11:39:59 +0100
Message-ID: <564j80F26j10eU1@mid.individual.net>


tech_Anay wrote on 18.03.2007 00:11:
> Hi,
>
> Is there any way to check if a particular table in Oracle is in normal
> forms 1,2,3 using SQL statements? Any pointers would be appreciated!

Normalization involves knowing the business behind the data model. You can't tell from a static description of tables and their columns if that model is normalized.

Thomas Received on Sun Mar 18 2007 - 05:39:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US