In the accompanying figure, what is the primary key field of the Tours table?
A) TourNo
B) Customers
C) Sales
D) Tours

Question

In the accompanying figure, what is the primary key field of the Tours table?
A) TourNo 
B) Customers 
C) Sales 
D) Tours

Quizplus · Accepted Answer

The primary key field of the Tours table is TourNo. This is indicated by the key symbol to the left of the field name in the table design. A primary key is a unique identifier for each record in a table, and TourNo appears to be the appropriate field for this purpose in the Tours table. Customers and Sales are not appropriate for a primary key field, and Tours is the name of the table itself, which cannot be used as a primary key field.

In the Accompanying Figure, What Is the Primary Key Field