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. Any database tables that are in third normal form should:
A)Eliminate repeating groups.
B)Eliminate redundant data.
C)Eliminate columns not dependent on the primary key.
D)All of the above.

Question

Quizplus · Accepted Answer

All three options mentioned in the answer choice are characteristics of tables in third normal form. Third normal form (3NF) requires a table to eliminate repeating groups, eliminate redundant data, and make sure that all columns are dependent on the primary key. Therefore, the best choice is D.

Booksellers of Bufluffia Is a Small, Independent Bookstore That Both