What does a primary key do in an ER model?
Correct Answer: A primary key uniquely identifies a record in a database table.
- Step 1: Understand that a database table is like a spreadsheet with rows and columns.
- Step 2: Each row in the table represents a unique record, like a single person or item.
- Step 3: A primary key is a special column in the table that gives each row a unique identifier.
- Step 4: This means no two rows can have the same value in the primary key column.
- Step 5: The primary key helps us find, update, or delete a specific record easily.
No concepts available.