Re: Entity vs. Table
Date: Mon, 14 Jun 2004 11:05:34 -0400
"Alfredo Novoa" <alfredo_at_ncs.es> wrote in message
> On Mon, 14 Jun 2004 09:16:27 -0400, "Alan" <alan_at_erols.com> wrote:
> >You start with business requirements, which you turn into an ERD. You
> >follow the rules referred to above, to turn it into an actual relational
> >schema. This is the physical model.
> Very very wrong!!
> This is the logical model!
I think we are really in agreement, but the use of wrods and relative point-of-view is getting in the way. Your view is certainly correct. Much of the confusion stems from the use of the term "model", which means different things to different people. So, how about this... (note that "model" is not used!)
The basic divisions are:
Conceptual Design (ERD or other)
Logical Design (Mapping to Relational Schema (tables)) flows to
Physical Design (Indexes, Storage Structures, and other RDBMS-independent items) Received on Mon Jun 14 2004 - 17:05:34 CEST