Foreign Key in VARRAYgreenspun.com : LUSENET : DBAzine : One Thread |
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