Re: Multiple entries in a field
Date: 2000/08/10
Message-ID: <399309c9.53762985_at_pubnews.netcom.net.uk>#1/1
On 9 Aug 2000 09:52:00 GMT, hidders_at_wsinis12.win.tue.nl (Jan Hidders) wrote:
>On Tue, 08 Aug 2000 22:33:29 GMT, Rohit <rohitd_at_flashmail.com> wrote:
>Roughly it works like this: For all the data items that you want to store you
>have to ask yourself the following questions:
>
>1. Does it describe the property of a thing and of what thing? E.g. the
> player name is a property of a a player and the founding date is a
> property of a team.
>
>2. Does it describe the property of a relationship between things and of
> what relationship? E.g. the year-of-joining is a property of the
> plays-for relationionship between player and team.
>
>Then, for every type of thing and every type of relationship that you have
>found you create a separate table that describes all the properties of this
>thing or relationship. In your example this would be tables PLAYER(Name, Age),
>PLAYES-FOR(Year-of-joining) and TEAM(Name, Founding-year).
>
Rohit.
"A crush,for humans,is something like falling in love; however it occurs only in very young members of the species and is looked upon with great amusement by the older members."
- Spock to Lt.Saavik,Star Trek II - The Wrath of Khan "I just want you to know - maybe we don't need to worry,but where I was raised it's good manners to tell you - I passed all my exams in biocontrol." - David (Capt. Kirk's son) to Lt.Saavik,just before having sex,Star Trek III - The Search For Spock