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.Which of the following junction tables is likely to be included in the database?
A)Clients/inventory
B)Clients/sales
C)Inventory/sales
D)All of these.

Question

Quizplus · Accepted Answer

Since Booksellers of Bufluffia publishes and sells their own books, it is likely that they will need a junction table to link their inventory with sales. This can be achieved through an inventory/sales junction table, which will help track which books were sold to which clients. Junction tables for clients and inventory, as well as clients and sales, may also be useful, but they are not as critical to the bookstore's operations as the inventory/sales junction table.

Booksellers of Bufluffia Is a Small, Independent Bookstore That Both