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

Home -> Community -> Usenet -> comp.databases.theory -> Re: Proposal: 6NF

Re: Proposal: 6NF

From: David Cressey <dcressey_at_verizon.net>
Date: Thu, 19 Oct 2006 11:30:17 GMT
Message-ID: <dlJZg.5549$Dg5.4204@trndny09>

"dawn" <dawnwolthuis_at_gmail.com> wrote in message news:1161181554.994352.69970_at_m7g2000cwm.googlegroups.com...
> David Cressey wrote:
> By the way, if not working with SQL where OTLT is rightly considered a
> no-no, there are many environments where a single validation table for
> many varied user-defined domains is still popular (and after reviewing
> it some months back I would posit that it is still worth considering as
> a "best practice" ;-) Cheers! --dawn

OTLT is a bad practice when working with relational systems as well as SQL.

Why would you ever consider it a "best practice" in any environment? What does it buy you? Received on Thu Oct 19 2006 - 06:30:17 CDT

Original text of this message

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