Re: Date of Birth as an attribute

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 - 17:13:38 CEST