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

Question

Convert the following table to first normal form:​ Branch (BranchNum,BranchName,(BookCode,Title,OnHand))
A) ​Branch (BranchNum, BranchName)?Book (BookCode, Title)
B) ​Branch (BranchNum, BranchName)
C) ​Book (BookCode, Title)
D) ​Branch (BranchNum, BranchName, BookCode, Title, OnHand )

Quizplus · Accepted Answer

To convert the table to first normal form, we need to eliminate the repeating groups. In this case, the repeating group is the list of books with their respective on-hand quantities. Option D eliminates the repeating group by having separate columns for BookCode, Title, and OnHand. This also allows for easier querying and manipulation of the data. Options A, B, and C do not address the issue of the repeating group and do not fully normalize the table.

Convert the Following Table to First Normal Form:​ Branch (BranchNum,BranchName,(BookCode,Title,OnHand))

Convert the Following Table to First Normal Form: Branch (BranchNum,BranchName,(BookCode,Title,OnHand))