> 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