Primary key
- the field that uniquely represents each record in a table
- also known as the unique identifier
Foreign key
- a field that matches the primary key in the other key
- may have duplicate values
Importance of primary key:
1. helps avoid duplicating records
2. prevents null values
No comments:
Post a Comment