| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Relation or attribute and why
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 - 05:41:44 CDT
![]() |
![]() |