variable number of foriegn keys

From: Yoo-Shin Lee <yoosh_at_sawnlk.cs.ualberta.ca>
Date: 1995/10/08
Message-ID: <457haq$maj_at_scapa.cs.ualberta.ca>#1/1


Hello,

I want to associate a variable number of foreign keys to a record:

        Example record of a house

	House Address: 4016-99 street
	Description: a little red house
	Family Members: john, mary, martha /* THIS IS THE variable field

So the Family Members field is taken from a relation people:

        Example record in people

	Name: john /* this is the primary key in people
	Age: 22
	favorite food: pizza 


Is something like this possible in oracle? having records in a relation being able to have more than one foreign key associated with it?

Thanks.

--
			Yoo-Shin Lee
			yoosh_at_cs.ualberta.ca
			http://web.cs.ualberta.ca/~yoosh
Received on Sun Oct 08 1995 - 00:00:00 CET

Original text of this message