Convert the following table to first normal form:?Branch (BranchNum, BranchName, (BookCode, Title, OnHand) ) where BranchNum is the primary key
A) Branch (BranchNum, BranchName) where BranchNum is the primary key?Book (BookCode, Title) where BookCode is the primary key
B) Branch (BranchNum, BranchName) where BranchNum is the primary key
C) Book (BookCode, Title) where BookCode is the primary key
D) Branch (BranchNum, BranchName, BookCode, Title, OnHand ) where BranchNum and BookCode make the primary key

Question

Quizplus · Accepted Answer

The table in its original form is not in first normal form because it contains a repeating group of (BookCode, Title, OnHand) within the Branch table. To convert it to first normal form, we need to remove the repeating group and create a separate table for books. However, simply creating a Book table as in option C would not be sufficient because it does not take into account the relationship between branches and books.

Option A is not a good choice because it eliminates the information on book inventory at each branch. Option B is also not ideal because it separates the book information from the branch information and requires a separate table to link them.

Option D is the best choice because it creates a separate Book table while also maintaining the relationship between branches and books through the use of a composite primary key (BranchNum, BookCode). This allows us to store information on book inventory at each branch and easily query for a specific branch or book.

Convert the Following Table to First Normal Form:?Branch (BranchNum, BranchName