Re: variable number of foriegn keys

From: Paul Baumgartel <paulb_at_pcnet.com>
Date: 1995/10/08
Message-ID: <458m43$smd_at_pcnet2.pcnet.net>#1/1

yoosh_at_sawnlk.cs.ualberta.ca (Yoo-Shin Lee) wrote:
>
>Hello,
>
>I want to associate a variable number of foreign keys to a record:
 [snip]
>Is something like this possible in oracle? having records in a relation
>being able to have more than one foreign key associated with it?

This is a one-to-many relationship. A house can have 1 or more residents. So your design should be:

House

---

house ID
address
description

People

---

person ID
name
age
house ID /* FK referencing house.house_id */ Received on Sun Oct 08 1995 - 00:00:00 CET