Path: news.cambrium.nl!textnews.cambrium.nl!feeder1.cambriumusenet.nl!feed.tweaknews.nl!83.128.0.12.MISMATCH!news-out2.kabelfoon.nl!newsfeed.kabelfoon.nl!bandi.nntp.kabelfoon.nl!feeder.news-service.com!postnews.google.com!j18g2000yqd.googlegroups.com!not-for-mail
From: Erwin <e.smout@myonline.be>
Newsgroups: comp.databases.theory
Subject: Re: Designing DB in accordance with the relational model
Date: Thu, 11 Nov 2010 02:48:10 -0800 (PST)
Organization: http://groups.google.com
Lines: 61
Message-ID: <b5e63db1-cc25-4a06-a559-97d7b05952b0@j18g2000yqd.googlegroups.com>
References: <acae2d76-e8e2-493a-9f88-c9d5ff7624a2@x42g2000yqx.googlegroups.com>
 <0cc6a410-1d21-4d9c-b6c2-f765bf666d5f@r29g2000yqj.googlegroups.com>
 <103c675a-f7d6-4c51-a4b2-e04bd06c9a64@y23g2000yqd.googlegroups.com>
 <p04md6hgir4vhji1p2htmt0rc8gtrkjstc@4ax.com> <383ee2a6-1142-4f42-a548-bebe99b43c55@v20g2000yqb.googlegroups.com>
NNTP-Posting-Host: 85.234.202.210
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1289472490 20542 127.0.0.1 (11 Nov 2010 10:48:10 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 11 Nov 2010 10:48:10 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: j18g2000yqd.googlegroups.com; posting-host=85.234.202.210; posting-account=-nQufgoAAABsreOCZNqo2Uyh8O-fYVPT
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727),gzip(gfe)
Xref:  news.cambrium.nl

On 11 nov, 00:54, Kentauros <joker...@gmail.com> wrote:
> On Nov 11, 12:39=A0am, Hugo Kornelis
>
> <h...@perFact.REMOVETHIS.info.INVALID> wrote:
>
> On Nov 11, 12:10=A0am, Erwin <e.sm...@myonline.be> wrote:
>
> > ??????
>
> > By including a relvar for that purpose in your DB design. =A0Plus the
> > needed relvars or attributes for documenting how characters relate to
> > games.
>
> Allright. The second approach.
>
> TYPE GAME POSSREP GAME {S =A0CHAR};
> TYPE ELEMENT POSSREP ELEMENT {S CHAR};
>
> TABLE Games {Game GAME, =A0OrdinalNumber INT}
> =A0 PRIMARY KEY {Game};
> TABLE CharactersExistence{Character# CHAR_ID, =A0CharacterName CHAR,
> Game GAME}
> =A0 PRIMARY KEY {Character#, Game},
> =A0 FOREIGN KEY {Game} REFERENCES TO Games;
> TABLE ElementsExistence{Element ELEMENT, =A0Game GAME}
> =A0 PRIMARY KEY {Element},
> =A0 FOREIGN KEY {Game} REFERENCES TO Games;
>
> But it seems that the table Characters has to go =97 characters have
> different sets of characteristics in different games,

Then you need a relvar(/table) for the predicate "<character> has
characteristic <characteristic> in game <game>.".

Plus perhaps an inclusion dependency (aka FK) to the relvar that holds
the true instances of the predicate ""<character> appears in game
<game>.".  If you have a need for such a relvar (which will
essentially be the case if characters can appear in a game without any
characteristics).



> and I can't
> predict what will (dis)appear or which remained characteristic change
> -- except for name. I think I'd want to have a relation with predicate
> like "Characteristic <Name> with type <Type> existed in game <Game>",
> and I know how to do this... but I'm afraid of it and won't do it.

Well, then we're basically done talking.

BTW, did you consider that you didn't mention at all what it means
_precisely_ for you to "be a game" ?  And that you might be causing
confusion in doing so ?  By "a game" do you mean something like
"Monopoly" (meaning it means more something like "a type of game"), or
do you mean "the game of Monopoly that was played between x, y and z
on april, 1 at 2PM" ?

To you, it's probably obvious.  Learn to realise that to others, it
usually isn't.