The correct option is C. primary key. Explanation of the Correct Answer A primary key is a specific field (or a combination of fields) in a database table that is used to uniquely identify each record in that table. Here’s a detailed breakdown of why the primary key is the correct answer:

1. Uniqueness: The primary key must contain unique values. This means that no two records can have the same value for the primary key field. For example, in a table of students, the student ID could serve as a primary key because each student has a unique ID.
2. Non-nullability: A primary key cannot contain NULL values. Every record must have a value for the primary key field. This ensures that every record can be identified without ambiguity.
3. Stability: The values in a primary key should not change frequently. If a primary key value changes, it can lead to complications in maintaining relationships with other tables in the database.
4. Single Field or Composite: A primary key can be a single field (like a student ID) or a combination of multiple fields (like a combination of first name, last name, and date of birth) that together ensure uniqueness.

Why the Other Options are Incorrect

• A. Foreign Key:
• A foreign key is a field (or collection of fields) in one table that refers to the primary key in another table. Its purpose is to establish a link between the two tables. While it helps maintain referential integrity, it does not uniquely identify records within its own table.
• B. Local Key:
• The term "local key" is not a standard term in database terminology. It may refer to a key that is used within a specific context or scope, but it does not have a defined meaning in the context of uniquely identifying records in a database. Therefore, it is not a valid option.
• D. Secondary Key:
• A secondary key is an attribute or a set of attributes that can be used to access records in a database but does not guarantee uniqueness. Secondary keys can be used for searching and sorting but are not designed to uniquely identify records like a primary key.

Summary of Key Points

• A primary key uniquely identifies each record in a database table.
• It must contain unique values and cannot be NULL.
• It can be a single field or a combination of fields.
• Other options like foreign keys and secondary keys serve different purposes and do not fulfill the requirement of uniquely identifying records.

Revision Summary

• The primary key is essential for uniquely identifying records in a database.
• It must be unique and cannot contain NULL values.
• Foreign keys link tables but do not uniquely identify records.
• Understanding the role of different types of keys is crucial for effective database design.