Question: How do you foreign key multiple tables that don't have any columns in common Such as the following 3 tables without adding columns to any

How do you foreign key multiple tables that don't have any columns in common Such as the following 3 tables without adding columns to any of the tables?

Table 1: 

Create Table Person
(
PersonID Integer,
Name Char(50),
Gender char(6),
Primary Key(PersonID)
)

 

Table 2: 

Create Table Parents

(

ParentID Integer,

ChildID)

 

Table3: 

Create Table Spouse

(

Spouse1ID Integer,

Spouse2ID Integer

)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Solution Foreign keys are typically used to establish relationships between tables based on common c... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!