2 deleted 3 characters in body
source | link

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)

BOOK (BookTitle, AuthorName, BookType, ListPrice, AuthorAffil, Publisher)

AuthorAffilAuthorAffil refers to the affiliation of author. Suppose the following functional dependenciesdependencies exist:

{BookTitle} --> {Publisher, BookType}
{BookType} --> {ListPrice}
{AuthorName} --> {AuthorAffil}

{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}
 

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.

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.

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.

    Tweeted twitter.com/#!/StackDBAs/status/478802910780723200
1
source | link

Database Normalization

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.