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/inventory junction table, its primary key is most likely to be:
A)The same as the primary key of the sales table.
B)The same as the primary key of the inventory table.
C)A compound primary key.
D)None of these

Question

Quizplus · Accepted Answer

Since the junction table will link sales and inventory data, it will likely have a compound primary key made up of foreign keys from both the sales and inventory tables. This will ensure that each sale is related to the appropriate inventory item and vice versa.

Booksellers of Bufluffia Is a Small, Independent Bookstore That Both