RE: Database Normalization

Funny you should ask for this definition.

Boyce-Codd Normal Form (BCNF)

* Formal definition:
* Every determinant must be a candidate key
* Stronger form of 3NF
* 3NF:  Every determinant of a non-key column must be a candidate key
* Applies to tables with more than one candidate key
* Candidate keys are alternatives to the "chosen" primary key

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation

Direct:	(313) 227-4350
Mobile:	(248) 408-2918
Email:	Stephen.Karniotis_at_Compuware.com 
Web:	www.compuware.com 

 -----Original Message-----
Sent:	Monday, November 03, 2003 2:05 PM
To:	Multiple recipients of list ORACLE-L
Subject:	Re: Database Normalization

 << File: reply >> ive seen tom kyte say the same thing. normalize unless its bad for design and/or hurts performance.

which is similiar to normalize until its inconvenient.

you could have some real fun and try to explan the boyce-codd normal form from an academic text book :)
>
> From: Jared.Still_at_radisys.com
> Date: 2003/11/03 Mon PM 01:34:26 EST
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: Database Normalization
>
> List,
>
> Doing some reading on Normalization today. We actually have the
> opportunity
> to create a database and app, and it's been so long since I've done this
> on a real
> project, a refresher was in order.
>
> I have the annoying habit of knowing what to do with normalization, based
> on past
> education and experience, but having difficulty explaining it to others.
> This is the kind
> of thing that makes Cary Millsap nuts. ( read the book if you don't know
> why )
>
> Mladen would no doubt find this very simple.
>
> Anyway, in the course of finding some recent web pages on this, one of the

> better
> was at a SQL server magazine site:
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887&pg=1
>
> The reason for writing however, was to show you the worst one so far:
> www.tinyurl/th7i
>
> Basically, 'normalize unless it's inconvenient'.
>
> Jared
>
>

The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Karniotis, Stephen
  INET: Stephen_Karniotis_at_compuware.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).