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 a sales/inventory table.You would expect to find all of the following fields in that table except:
A)Sales transaction number
B)Inventory item number
C)Quantity purchased
D)Total amount billed

Question

Quizplus · Accepted Answer

The total amount billed would typically be calculated from the quantity purchased and the price of the item, rather than stored directly in a sales/inventory table. This table would more likely include fields directly related to the transaction details and inventory tracking, such as sales transaction number, inventory item number, and quantity purchased.

Booksellers of Bufluffia Is a Small, Independent Bookstore That Both