Re: Relation or attribute and why

From: Tony Andrews <andrewst_at_onetel.com>
Date: 23 May 2006 03:41:44 -0700
Message-ID: <1148380904.264427.209030_at_g10g2000cwb.googlegroups.com>


dawn wrote:
> Because it is composed to two attributes that are "easier" to implement
> on their own without dragging the immediate "relation" to which they
> belong into the picture. Instead of Person(personId, nameId, ...) plus
> Name(nameId, firstName, lastName) it is more often modeled as
> Person(personId, firstName, lastName...)
>
> Why? What rule or practice is being employed when we drop a noun like
> "name" when going from a CDM to an LDM? Thanks. --dawn

Occam's razor? There is no gain (that I can think of) in separating a person's name into a separate table Name that has a 1:1 relationship with the table Person, while there is a cost in terms of complexity. Received on Tue May 23 2006 - 12:41:44 CEST

Original text of this message