Solved

Can a PK be an FK as well ?

Posted on 2007-11-15
3
1,102 Views
Last Modified: 2008-03-23
Hello,

Can a PK be an FK as well ?

Thank you.
0
Comment
Question by:matthew016
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 20

Assisted Solution

by:steelseth12
steelseth12 earned 200 total points
ID: 20292600
foreign key of one table is the primary key of another table.
For the field to be the primary key of table A and the foreign key of table B ... No. Foreign key needs to take the values from table B.
0
 
LVL 1

Accepted Solution

by:
kiwi_nz earned 300 total points
ID: 20295410
yes a pk can be an fk - however this must be done in a special way. The trick is you must have two foreign keys that then composite into a Primary key - this is useful for when tables would otherwise have a many to many relationship you can put an intermediary table in between them and use the PK from each primary table as an FK in the intermediary table thereby creating a one to many - int table - many to one relationship.

Personally I dislike this method and always give the intemediary table a primary key and then add the two FK's thus making sure every single record in every single table is unique
0
 
LVL 9

Author Comment

by:matthew016
ID: 21189650
The answer was just yes, no special way needed
0

Featured Post

Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
In this tutorial viewers will learn how to create blended and gradiated shapes in Illustrator using the blend tool Draw two shapes, one of them in a different color: Select both and create a blend by going to Object > Blend > Make: Blends can also b…
In this second Micro Tutorial in the series,  viewers will learn more basic shortcuts and functions of Illustrator. In this tutorial you will learn about the eyedropper tool, zoom , ellipses and more.

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question