Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!news4.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!cyclone1.gnilink.net!spamkiller2.gnilink.net!gnilink.net!trndny05.POSTED!9244eeff!not-for-mail From: "David Cressey" Newsgroups: comp.databases.theory References: <1159558507.190840.68280@m7g2000cwm.googlegroups.com> Subject: Re: Proposal: 6NF Lines: 24 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Message-ID: Date: Sat, 30 Sep 2006 13:14:13 GMT NNTP-Posting-Host: 72.70.250.107 X-Complaints-To: abuse@verizon.net X-Trace: trndny05 1159622053 72.70.250.107 (Sat, 30 Sep 2006 09:14:13 EDT) NNTP-Posting-Date: Sat, 30 Sep 2006 09:14:13 EDT Xref: dp-news.maxwell.syr.edu comp.databases.theory:45435 "Karen Hill" wrote in message news:1159558507.190840.68280@m7g2000cwm.googlegroups.com... > 6NF would be a database that uses no Nulls. > > This way, one could specify that they demand their relations in 6th > Normalized Form, and have a database design that uses no Nulls. > > Those that like nulls can have thier 3NF, while the rest of us reach > for higher standers like 6NF. > > regards, > > Karen > First, let's find out where we all agree, then work our way towards where there are different viewpoints. Here's a starter: A schema in DKNF will have no nullable columns.