A primary key is a column in a table where each value is unique and identifies a specific row.
Try it with AIIn database management and data modeling within Excel, a primary key ensures that no two rows contain the same data in that column. It serves as a unique identifier, preventing duplicate records and enabling accurate data relationships between tables.
In an Employee table, an 'Employee ID' column acts as a primary key because every employee is assigned a unique number that never repeats.
No, a primary key must contain a unique value for every row and cannot be blank.