Re: Checking if a table is normalized using SQL

tech_Anay wrote:
> 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!
>
>
> Thanks.
>
> TechArl
>

Maybe if the database had some semblance of the defined Functional Dependencies, you might be able to query the DB to find out this information. But since that information is lacking in the DB, you can't query about it.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com