Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Multiple entries in a field

Re: Multiple entries in a field

From: <mikepreece_at_my-deja.com>
Date: Mon, 21 Aug 2000 12:25:32 GMT
Message-ID: <8nr73f$5rs$1@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 - 07:25:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US