34 Views

what is the difference between primary key and foreign key in database.


Rajiv kumar Prabhakar 30th May, 2021
Answer (1)
Palak kumari 30th 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!

Related Questions

Amity University, Noida Law A...
Apply
700+ Campus placements at top national and global law firms, corporates and judiciaries
Nirma University Law Admissio...
Apply
Grade 'A+' accredited by NAAC | Ranked 33rd by NIRF 2025
Amity University Noida B.Tech...
Apply
Among Top 30 National Universities for Engineering (NIRF 2024) | 30+ Specializations | AI Powered Learning & State-of-the-Art Facilities
IMT Ghaziabad PGDM Admissions...
Apply
AACSB, NBA & SAQS Accredited | H-CTC 41.55 LPA | Merit Based Scholarship
Amity University, Noida BBA A...
Apply
Ranked amongst top 3% universities globally (QS Rankings)
UPES Online MBA
Apply
Apply for Online MBA from UPES
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