What is a primary key?
Correct Answer: A primary key is a unique identifier for a record in a database table.
- Step 1: Understand that a database is like a digital filing cabinet where information is stored in tables.
- Step 2: Each table has rows (records) and columns (fields or attributes).
- Step 3: A primary key is a special column in a table that holds unique values.
- Step 4: The unique values in the primary key column ensure that each record can be identified separately.
- Step 5: No two records in the table can have the same primary key value, which prevents confusion.
- Step 6: Think of the primary key like a Social Security Number; each person has a unique number that identifies them.
No concepts available.
