Re: Multiplicity, Change and MV

From: x <x_at_not-exists.org>
Date: Fri, 14 Apr 2006 13:09:07 +0300
Message-ID: <e1nsas$1bp$1_at_emma.aioe.org>


"Neo" <neo55592_at_hotmail.com> wrote in message news:1144963850.288085.291890_at_t31g2000cwb.googlegroups.com...
> > I don't know your definition of schema.
> > I have searched Codd's 1970 ACM paper and found 0 occurences of this
word.

> Hmm. Interesting. My engineering background may have influenced my
> terminology. With respect to RMDBs, I use the term schema to mean the
> overall db structure that allows one to store data for a particular
> application.

Ok, if you feel confortable in your overalls.

>The main components of the structure being tables, fields,
> field types and the relationship between keys. When printed out from
> SQL Server or Access on a size E sheet via a plotter, some of my past
> projects displayed as many as 50 or 60 vertical rectangular blocks, the
> top of each labeled with the table name, listed within the box are the
> field names and crisscrossing lines connect the primary/foreign keys of
> various tables. Little icons on the diagonal lines indicate the
> relationship type (one-to-one, one-to-many).

Mine shows around 265 such rectangular blocks and it's growing.

>This sheet gets spreadout
> on the conference table at various meeting through out the project's
> life so that all the developers are on the same track.

Need to know policy might be better ?

> It the large
> sheet that typically hung behind me from the top of the cubicle divider
> to the floor and ended up with bloody marks from various color markers
> as the project progresses. If there is a more appropriate term, please
> advise.

Diagram ? Drawing ?
I used to make lots of these when I was a baby and discovered paper and color markers. Received on Fri Apr 14 2006 - 12:09:07 CEST

Original text of this message