Based on the statement below,which of the following is the primary key? Rep (RepNum,LastName,FirstName,Street,City,State,PostalCode Commission,Rate)
A) RepNum
B) LastName
C) FirstName
D) State

Question

​Based on the statement below,which of the following is the primary key? Rep (RepNum,LastName,FirstName,Street,City,State,PostalCode Commission,Rate)
A) ​RepNum
B) ​LastName
C) ​FirstName
D) ​State

Quizplus · Accepted Answer

A primary key uniquely identifies each record in a table. In this case, RepNum is the most logical choice as it is a unique identifier for each sales representative. The other fields may not necessarily be unique and could potentially have duplicates.

​Based on the Statement Below,which of the Following Is the Primary

Based on the Statement Below,which of the Following Is the Primary