Hello,

I have a table Player with PK player_id. I have another table Statistics (Stores yearly records of a soccer team). This table has a multivalued attribute "captains" that should list the player_id of all the players who were made captain during that particular year. I am thinking of implementing captains as VARRAY, but how can I implement referential integrity so that each captain in VARRAY refers to player_id in Player table.

Regards, Amit

-- Amit Parikh (amit_m_parikh@yahoo.co.in), February 11, 2005