Convert the following table to first normal form: Branch (BranchNum ,BranchName,(BookCode,Title,CopyNum,Quality,Price) ) A)Branch (BranchNum,BranchName) Book (BookCode ,Title,CopyNum) B)Branch (BranchNum,BranchName) C)Book (BookCode,Title,Copynum) D)Branch (BranchNum,BranchName, BookCode ,Title, CopyNum ,Quality,Price)

Question

Quizplus · Accepted Answer

The given table violates the first normal form because it has a repeating group of attributes (BookCode, Title, CopyNum, Quality, Price). To convert it to first normal form, we need to remove this repeating group and create a separate table for Books which will have the attributes (BookCode, Title, CopyNum) only. The original table will become Branch(BookCode, BranchNum, BranchName, Quality, Price). Therefore, the best choice is D, which has created a separate table for Books while also preserving all the original attributes.

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