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. Suppose the database includes four tables: clients, inventory, sales and sales / inventory. In which table(s) would you expect to see a field labeled "client ID?"
A)Clients table only
B)Sales table only
C)Both A and B
D)Neither A nor B

Question

Quizplus · Accepted Answer

The "client ID" field would be necessary in both the clients table (to identify and store information about each client) and the sales table (to associate each sale with a particular client).

Booksellers of Bufluffia Is a Small, Independent Bookstore That Both