Foreign Key in VARRAYgreenspun.com : LUSENET : DBAzine : One Thread
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.
-- Amit Parikh (firstname.lastname@example.org), February 11, 2005