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: Which normal form is this violating?

Re: Which normal form is this violating?

From: Cimarron Taylor <cimarron+google_at_taylors.org>
Date: 25 Apr 2002 22:53:30 -0700
Message-ID: <29e28c51.0204252153.1efee31a@posting.google.com> 





> The crazy thing about the design texts, is that they rarely 

> cover mistakes in design.  This is a common one.




Really?  Table_A is what Codd's RM/T model would call an E (entity)
relation and Table_B is what would be termed a P (property) relation.



There are some advantages to this model, particularly if you enforce
the constraint that all the E relation values are populated by immutable
system-generated surogates.



Cim
Received on Fri Apr 26 2002 - 00:53:30 CDT












Original text of this message













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