What is the purpose of a primary key in a database table?
Correct Answer: A primary key uniquely identifies each record.
- Step 1: Understand that a database table is like a spreadsheet with rows and columns.
- Step 2: Each row in the table represents a different record or entry.
- Step 3: A primary key is a special column in the table.
- Step 4: The primary key contains unique values for each row, meaning no two rows can have the same value in this column.
- Step 5: This uniqueness helps to easily find, update, or delete specific records in the table.
- Step 6: Think of the primary key like a student ID number; each student has a different ID that identifies them.
No concepts available.
