Multiple foreign keys from one table

Question

0.00/5 (No votes)

See more:

Good day Guys,

I have a problem concerning normalization. I have 2 tables, one have locations and one has trips. in order a trip to be complete it consist of 2 locations and a location table is normalized. is it possible that my trip table can have 2 foreign keys? Your answers would be appreciated.

Posted 28-Jan-13 3:36am

Lulamile Gaji

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

fjdiewornncalwe · Answer 1 · 2013-01-28T03:42:00

Solution 1

Absolutely. In fact, that is a very common occurrance. Just go ahead and create both foreign keys in the table and all will be well. As Zoltan has pointed out in his comment to this question, this is actually a very natural and fundamental part of the normalization process. See this article for a decent explanation: Database normalization starts with the keys[^]

Posted 28-Jan-13 3:42am

fjdiewornncalwe

Updated 28-Jan-13 3:57am

v3

Comments

Zoltán Zörgő 28-Jan-13 9:53am

True. Just an addition: the normalization itself is the root cause of the growth of foreign keys in a table.

fjdiewornncalwe 28-Jan-13 9:55am

Excellent point. I'll add that in.

Sergey Alexandrovich Kryukov 28-Jan-13 13:18pm

Agreed, a 5.
—SA

fjdiewornncalwe 28-Jan-13 15:10pm

Thanks, Sergey

Lulamile Gaji 29-Jan-13 2:16am

I meant 2 foreign keys from the same table?

fjdiewornncalwe 29-Jan-13 10:05am

I know that. Whether you have two foreign keys in a table pointing to different tables or the same table makes no difference.