RE: Codd Rules
The principles of the relational model were first outlined by Dr. E. F. Codd in June 1970. book: The Relational Model for Database Mgmt. V2 E. F. Codd, Addison Wesley. |-----Original Message----- |From: johnh [mailto:john.horton@cognito.co.uk] |Sent: Thursday, August 24, 2000 9:04 AM |To: Obnoxio The Clown |Cc: saviop75@hotmail.com; informix-list@iiug.org |Subject: Re: Codd Rules | | |Excuse my ignorance (or don't - if you are like that..) |but what are the codd rules? |is there a url or something (or even a book?!) that i could go to?? | |Obnoxio The Clown wrote: |> |> From: "Savio Mario Bartholomeo Pereira" <saviop75@hotmail.com> |> > |> > Any RDBMS should follow the Codd rules. |> >How many does Informix follow. |> >What are the rules that Informix follow. |> >What are the remaining rules that Informix doesn't |follow.Mention the |> >reasons for that. |> |> You want fries with that? |> |> |_______________________________________________________________ |_________ |> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- John Horton DBA Cognito (Informix on Linux) john.horton@cognito.co.uk sysadmin and mahjongg player use Tk;$mw=tkinit;$t='yet_another_perl_hacker!';$a=0;$c=$mw->Canvas(-width=>155, -height=>15);$c->create('text',80,9,-text=>$t);$c->pack();$c->CanvasBind('<M otion>'=>sub{my($x,$y)=($Tk::event->x,$Tk::event->y);$x=int(rand($mw->screen height));$y=int(rand($mw->screenwidth));$mw->geometry("+$x+$y");$a++;if($a== 5){exit;}});MainLoop;
So this would refer to normalization? If so, wouldn't that be more of a database design question rather than an RDBMS question? In article <8o3cj1$ld$1@news.xmission.com>, "Bhaskarla, Sunil" <Sunil.Bhaskarla@Eclipsys.com> wrote: > > The principles of the relational model were first outlined by Dr. E. F. Codd > in June 1970. > book: The Relational Model for Database Mgmt. V2 E. F. Codd, Addison Wesley. > > |-----Original Message----- > |From: johnh [mailto:john.horton@cognito.co.uk] > |Sent: Thursday, August 24, 2000 9:04 AM > |To: Obnoxio The Clown > |Cc: saviop75@hotmail.com; informix-list@iiug.org > |Subject: Re: Codd Rules > | > | > |Excuse my ignorance (or don't - if you are like that..) > |but what are the codd rules? > |is there a url or something (or even a book?!) that i could go to?? > | > |Obnoxio The Clown wrote: > |> > |> From: "Savio Mario Bartholomeo Pereira" <saviop75@hotmail.com> > |> > > |> > Any RDBMS should follow the Codd rules. > |> >How many does Informix follow. > |> >What are the rules that Informix follow. > |> >What are the remaining rules that Informix doesn't > |follow.Mention the > |> >reasons for that. > |> > |> You want fries with that? > |> > |> > |_______________________________________________________________ > |_________ > |> Get Your Private, Free E-mail from MSN Hotmail at > http://www.hotmail.com > > -- > John Horton DBA Cognito (Informix on Linux) > john.horton@cognito.co.uk > > sysadmin and mahjongg player > > use > Tk;$mw=tkinit;$t='yet_another_perl_hacker!';$a=0;$c=$mw->Canvas(-width=> 155, > -height=>15);$c->create('text',80,9,-text=>$t);$c->pack();$c->CanvasBind ('<M > otion>'=>sub{my($x,$y)=($Tk::event->x,$Tk::event->y);$x=int(rand($mw->sc reen > height));$y=int(rand($mw->screenwidth));$mw->geometry("+$x+$y");$a++;if( $a== > 5){exit;}});MainLoop; > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.
mars1972@my-deja.com wrote: > > So this would refer to normalization? If so, wouldn't that be more of a > database design question rather than an RDBMS question? No. Savio was referring to the 12 rules that Codd set down that define what an RDBMS is. To be fully compliant it must fully support all 12 rules. None do. Informix is actually closer than most but not by much. These go to what is and is not an RDBMS, by definition not marketing hype, and not to database design. One rule ALL RDBMSs fall down on is requiring and enforcing the existence of a unique primay key column or columns on every table. Informix supports primary keys and enforces their uniqueness if added but does not REQUIRE that every table have one. Art S. Kagel > In article <8o3cj1$ld$1@news.xmission.com>, > "Bhaskarla, Sunil" <Sunil.Bhaskarla@Eclipsys.com> wrote: > > > > The principles of the relational model were first outlined by Dr. E. > F. Codd > > in June 1970. > > book: The Relational Model for Database Mgmt. V2 E. F. Codd, Addison > Wesley. > > > > |-----Original Message----- > > |From: johnh [mailto:john.horton@cognito.co.uk] > > |Sent: Thursday, August 24, 2000 9:04 AM > > |To: Obnoxio The Clown > > |Cc: saviop75@hotmail.com; informix-list@iiug.org > > |Subject: Re: Codd Rules > > | > > | > > |Excuse my ignorance (or don't - if you are like that..) > > |but what are the codd rules? > > |is there a url or something (or even a book?!) that i could go to?? > > | > > |Obnoxio The Clown wrote: > > |> > > |> From: "Savio Mario Bartholomeo Pereira" <saviop75@hotmail.com> > > |> > > > |> > Any RDBMS should follow the Codd rules. > > |> >How many does Informix follow. > > |> >What are the rules that Informix follow. > > |> >What are the remaining rules that Informix doesn't > > |follow.Mention the > > |> >reasons for that. > > |> > > |> You want fries with that? > > |> > > |> > > |_______________________________________________________________ > > |_________ > > |> Get Your Private, Free E-mail from MSN Hotmail at > > http://www.hotmail.com > > > > -- > > John Horton DBA Cognito (Informix on Linux) > > john.horton@cognito.co.uk > > > > sysadmin and mahjongg player > > > > use > > > Tk;$mw=tkinit;$t='yet_another_perl_hacker!';$a=0;$c=$mw->Canvas(-width=> > 155, > > > -height=>15);$c->create('text',80,9,-text=>$t);$c->pack();$c->CanvasBind > ('<M > > > otion>'=>sub{my($x,$y)=($Tk::event->x,$Tk::event->y);$x=int(rand($mw->sc > reen > > > height));$y=int(rand($mw->screenwidth));$mw->geometry("+$x+$y");$a++;if( > $a== > > 5){exit;}});MainLoop; > > > > -- > # unrm / > ksh: unrm: not found > # man cpio > > Sent via Deja.com http://www.deja.com/ > Before you buy.