Primary Key
- A primary key is a field or combination of fields that uniquely identifies each record in a database table.
- It is a unique identifier for each record and ensures that each record is distinct and can be easily referenced.
- The primary key is used to enforce data integrity and maintain the accuracy and consistency of the database.
- It is a fundamental concept in database design and is crucial for the organization and retrieval of data.
Key Record
- "Key Record" is not a commonly used term in database management.
- It does not specifically refer to a field or concept used for identifying records in a database.
Unique Key
- A unique key is a field or combination of fields that ensures each record in a database table is unique.
- Unlike a primary key, a unique key does not necessarily serve as the main identifier for the record.
- It can be used to enforce uniqueness but does not have the same constraints as a primary key.
Field Name
- A field name refers to the name given to a specific attribute or column in a database table.
- It is used to identify and describe the type of data stored in that particular field.
Therefore, the correct answer is Primary Key. It uniquely identifies each record in a database table and is essential for maintaining data integrity and consistency.