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: Date of Birth as an attribute

Re: Date of Birth as an attribute

From: Alan <alan_at_erols.com>
Date: Wed, 7 Apr 2004 11:13:38 -0400
Message-ID: <c515qs$2ngco4$1@ID-114862.news.uni-berlin.de>


Yes, there is the conceptual/logical/physical paradigm, but it sometimes gets fuzzy as various terms seem to be used differently by different people-Some use logical to mean conceptual, and then use physical to mean logical because, i suppose, the logical usually gets mapped one-to-one to physical. In any event, the re-location of the attribute happens during normalization, which is the conversion from conceptual to logical. Logical to physical in the three paradigm construction is "just" the implementation of the logical design.

In any event, I agree that the extra step buys you something, even if only a bit of clarity in process. Great pun, BTW!

"Laconic2" <laconic2_at_comcast.net> wrote in message news:reednQMCbKLdkund4p2dnA_at_comcast.com...
> Just a terminology question, I can point it out without making a mountain
> out of a mole hill.
>
> I've always seen the "ER" model listed as the "conceptual model" rather
> than the "logical model".
>
> In this framework, you first turn the ER conceptual model into a
relational
> logical model, and then turn the logical model into a physical model.
>
> It's an extra step, but I think it buys you something.
>
> Again, I don't want to make a mountain out of a mole hill. The rows by
any
> other name would smell as sweet.
>
>
Received on Wed Apr 07 2004 - 10:13:38 CDT

Original text of this message

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