54 Views

What is difference between primary key and foreign key in database?


Priyashi Kumari 13th May, 2021
Answer (1)
Palak kumari 13th May, 2021

Hi there,

Primary key is the set of attributes that uniquely identifies the records of the table. If we apply primary key in a column then we cannot add duplicate value to it.

Foreign key is a non key attributes those whose values are derived from primary key of some other table.

Hope it helps!

For further queries do, let me know!

Related Questions

Amity University-Noida B.Tech...
Apply
Among top 100 Universities Globally in the Times Higher Education (THE) Interdisciplinary Science Rankings 2026
BML Munjal University | B.Tec...
Apply
A Hero Group Initiative | Up to 100% Scholarships | Highest CTC 32.99 LPA | Average CTC 8.45 LPA | Accepts JEE Score | Applications Closing Soon!
SRM University A.P UG Admissi...
Apply
UG Admissions Open 2026 | Highest CTC 52 LPA | Average CTC 9.09 LPA | 60+ Collaborations with the world's best Universities
SRM University Chennai BBA/MBA
Apply
NAAC A++ Accredited | Ranked #12 by NIRF
SRM University, Chennai Law U...
Apply
NAAC A++ Accredited | Ranked #11 by NIRF
Amity University-Noida MBA Ad...
Apply
Ranked among top 10 B-Schools in India by multiple publications | Top Recruiters-Google, MicKinsey, Amazon, BCG & many more.
View All Application Forms

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books