Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

Solution Foreign keys are typically used to establish relationships between tables based on common c... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Databases questions

Question

What are the possible sources of error in this project?

Answered: 1 week ago