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
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.
Narayana Business School MBA/...
Apply
Top 30 Private B-Schools Nationally and Top 3 in Gujarat | Highest CTC- 20 LPA | Average CTC- 8.4 LPA | 40% Pre-Placement Offers | 670+ Recruiters 
Amity University | M.Tech Adm...
Apply
Asia’s only university to be awarded the highest accreditation by WASC, USA and by the Quality Assurance Agency for Higher Education (QAA), UK
JAGSoM PGDM Admissions 2026
Apply
Highest CTC 51.38 LPA | Median CTC 10.32 LPA | Top 25% Average CTC 14.32 LPA
IFMR Graduate School of Busin...
Apply
Application Deadline 15th Jan’26 | UGC Approved Programs | Near 100% Placement Record | Up to 100% Scholarships | Highest CTC 21.32 LPA
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