Dana is creating a table that will show books for sale on a bookstore's website.Which field in the table would best serve as its primary key?
A) Author
B) PageCount
C) Title
D) ProductID

Question

Quizplus · Accepted Answer

ProductID is the best choice for a primary key as it is a unique identifier for each book for sale on the website. The other options, such as Author or Title, may not be unique and could potentially have multiple books with the same author or title, leading to confusion in the table. PageCount is also not a reliable identifier as it may vary for different editions or formats of the same book.

Dana Is Creating a Table That Will Show Books for Sale