Re: Multiple entries in a field
Date: Mon, 21 Aug 2000 12:25:32 GMT
Message-ID: <8nr73f$5rs$1_at_nnrp1.deja.com>
This is what I'd do on a Pick database
In article <39908ab8.3789919_at_pubnews.netcom.net.uk>,
rohitd_at_flashmail.com (Rohit) wrote:
> Hi,
>
> I'm new to databases and designing them,so I hope I can get my
requirement
> through clearly.What I basically want to have is the possibility for
the entry
> of more than 1 data item for a particular field in my database.Eg.
for a
> database called TEAMS,I want fields such as: Name,Captain,Players,Year
> Founded,etc.
Teams
Key : Team
001: Name 002: Player (multivalued) 003: Date Founded (in internal format)
(004 etc...)
>Now obviously the last one has to have the names for *each* of the
> team,so it can't be done with just a VARCHAR(50).There will be a
separate
> database for each of the team,with things such as their Name,Age,Year
of
> joining,etc....
Players
Key : Player
001: Captain indicator (Y/Null) 002: Name 003: Date of Birth 004: Date Joined
(005 etc)...
> or should there be? How exactly would I go about doing this? I
> should be able to query the first db for all teams founded after a
certain
> year,for example,and then get whatever data on each member of that
team.
>
Dict,Teams
Key: Team 001: A 002: 1 003: Team Name 009: T 010: 30 Key: Founded 001: A 002: 3 003: Year Founded 007: DY
009: R
010: 12
Key: Captain 001: S 002: 2 003: Captain? 008: TPLAYERS;X;;1 009: R 010: 8 Key: PlayersName 001: S 002: 2 003: Player's Name 008: TPLAYERS;X;;2
009: T
010: 30
Key: PlayersAge 001: s 002: 0 003: Age 007: D2Y 008: A(D-2(TPLAYERS;X;;3)) 009: R 010: 3 Key: PlayerYrJoined 001: s 002: 2 003: Year Joined 007: DY 008: TPLAYERS;X;;4
009: R
010: 11
LIST TEAMS WITH FOUNDED > "01/01/1999" BY FOUNDED TEAM FOUNDED PLAYERSNAME CAPTAIN PLAYERSAGE PLAYERYRJOINED<cr>
TEAMS Team Name..................... Year Founded Player's Name................. Captain? Age Year Joined 001 Goodies 1999 John Smith Y 34 1999 Barry Brown 33 1999 Tom Harris 32 2000 002 Baddies 2000 Joe Black Y 31 2000
2 items listed.
There's no problem if you want to extend either file (you can add new fields while the database is in use). The world is your oyster.
hth.
Cheers,
Mike.
> Thanks a lot for your help,
>
> Ro.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Aug 21 2000 - 14:25:32 CEST