Booksellers of Bufluffia is a small, independent bookstore that both publishes and sells very specialized titles.They currently have about 50 clients; they publish and sell 30 different books at present.The company's management has asked you to create database tables to support their operations.If the database includes a "sales" table, its primary key is most likely to be:
A)Transaction date
B)Client name
C)Transaction number
D)Total revenue earned

Question

Quizplus · Accepted Answer

The primary key of the "sales" table should be a unique identifier for each transaction, which would be the transaction number. The transaction date and total revenue earned can be included as additional fields in the table, but are not appropriate choices for the primary key. Client name may be included as a field, but is also not appropriate as the primary key, as multiple clients may have multiple transactions with the bookstore.

Booksellers of Bufluffia Is a Small, Independent Bookstore That Both