hi all,

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.

Any ideas how to set up?

thanks

Trajano