Consider the following relation BOOKBooktitle Author Booktyp

Consider the following relation:

BOOK(Book_title, Author, Book_type, ListPrice, Author_affiliation, Publisher)

And, assume that the following dependencies exist:

Book_title à Publisher, Book_type

Book_type --> ListPrice

Author --> Author_affiliation

Present the best set of normalized relations for the above set of data.

Solution

Please find the answer below:

The best set of normailzed form for the given relation is :

BOOK (Book_title, Author, Publisher, Book_type) : Here Book_title is the primary key. Book_type and Author are secondary keys

BOOK_TYPE (Book_type, ListPrice) : Here Book_type is the primary key which refers Book_type column of the BOOK table

AUTHOR (Author, Author_affliliation) : Here Author is the primary key which refers to the Author column of the BOOK table