Difference between Primary key and Foreign Key | CBSE BOARD EXAM 2024 CLASS 12 |Important Question

@pythontyro4579
Difference between Primary key and Foreign Key
Primary key VS Foreign Key
Primary Key:
- Unique identifier for each record in a table
- Ensures data integrity and uniqueness
- Cannot be null or duplicated
- Example: Employee ID, Customer ID
Foreign Key:
- Field in a table that references the primary key of another table
- Establishes relationships between tables
- Ensures data consistency and prevents orphaned records
- Example: Order ID referencing Customer ID, Product ID referencing Category ID
#cbse #cbseclass12 #cbseclass11 #cbseclass12preparation #cbseboard #cbse2024_25 #cbse2024 #cbse2025 #cbse2020 #cbse2021 #cbse2022 #cbse2023_24 #cbsepreparation #cbsetoppers #cbsetuition #cbsetoppers #cbsestudymaterial #cbsesolutions #cbsecomputereducation #cbsecomputer #CBSE #cbseguide #cbseboard #cbseschool #cbsestudent #cbseschools #cbseclass10 #cbsecs #cbseimportantquestionsforexam #cbseimporantportions #cbseicse #cbseimprovementexam #cbsenotes #cbserevision