107k views
5 votes
No two records can have the same value in the primary key field. True or False?

1) True
2) False

1 Answer

6 votes

Final answer:

The statement 'No two records can have the same value in the primary key field' is True.

Step-by-step explanation:

The statement 'No two records can have the same value in the primary key field' is True. In database management, a primary key is a unique identifier for each record in a table. It ensures that no two records have the same value in the primary key field. Primary keys are essential for data integrity and to maintain the uniqueness of records within a table.

For example, let's consider a table of students with a primary key field called 'student_id'. Each student_id should have a unique value assigned to it. This ensures that each student in the table can be uniquely identified and no duplicate records exist.

User Elizafox
by
8.6k points

No related questions found