hi Martijn,

Thanks for your fast response.

Do you think if we set-up a table named contacts, containing,
name_id
firstname
surnmae
dateofbirth

Above table would contain names for players, mother and father. Then
somehow, create another table to link player with mother and father.
Is it possible?

thanks

Trajano

--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

>
> > we have a need to design a FireBird database for a soccer club, and we
> > would like to receive suggestions, links, etc how to design properly.
> >
> > The main table is the PLAYER, including player id as primary key. This
> > table shall have:
> > playerid,
> > firstname,
> > surname,
> > date of birth,
> >
> > We would like to set a CONTACT table, linking the player id with
> > details such as:
> > address
> > surburb
> > state
> > post code
> > phone
> > eMail
> >
> > The trick is we would like to set up another table containing parents
> > details, such as father and mother.
>
> PARENTS
> ---
> ParentID
> Firstname
> Lastname
> Sex
>
>
> PLAYER_PARENT
> ------
> ParentID
> PlayerID
>
> With regards,
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle &

MS SQL

> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com