If someone could guide me on helping me understand if my results are correct I would appreciate that. Let's say I have the following table:
BOOK (BookTitle, AuthorName, BookType, ListPrice, AuthorAffil, Publisher)
AuthorAffil
refers to the affiliation of author. Suppose the following functional dependencies exist:
{BookTitle} -> {Publisher, BookType}
{BookType} -> {ListPrice}
{AuthorName} -> {AuthorAffil}
I am asked if this table is in 1NF, 2NF, or 3NF.
I believe this table is in 1NF because no two rows of data contain repeating information.
If this was to be a 2NF, it would have to look like:
R1 = {BookTitle} -> {Publisher, BookType, ListPrice}
R2 = {AuthorName} -> {AuthorAffil}
R3 = {AuthorName, BookTitle} -> {extras}
I would like some help to know if I am understanding this concept or if there are any mistakes. Any type of help is welcomed.