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_at_posting.google.com>
Date: 25 Apr 2002 22:53:30 -0700
Message-ID: <29e28c51.0204252153.1efee31a_at_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 - 07:53:30 CEST