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 #boardexam #cbseclass11 #dbmstutorials #dbms #boardexam2024 #education #computersciencestudents #shorts #shortvideo