Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Do foreign keys have to be part of a primary key?

April 26, 2017foreign key keys primary

0

Posted

Do foreign keys have to be part of a primary key?

1 Answer

0

Posted

No. A foreign key may be part of a primary key, but very often it is not. Compare, in the students database, the foreign keys courses.dno and options.sno. One is part of a primary key and the other isn’t.