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 table(s) should be in third normal form?
A)The client table only
B)The books table only
C)Both the client table and the books table
D)Neither the client table nor the books table

Question

Quizplus · Accepted Answer

To be in third normal form, a table must meet two requirements: every non-key attribute in the table must be dependent on the primary key, and there can be no transitive dependencies. In this case, both the client and books tables have non-key attributes (such as client phone numbers or book authors) that are dependent on the primary key (client ID or book ISBN), and there are no transitive dependencies. Therefore, both tables should be in third normal form.

Booksellers of Bufluffia Is a Small, Independent Bookstore That Both