For the table BOOKAUTHOR below you are given the following functional dependencies. BOOKAUTHOR (ISBN, BookTitle, Author_Num, LastName, Publisher, Royalty, Edition) Functional dependencies: 1. ISBN BookTitle, Publisher, Edition 2. Author Num → LastName 3. BookTitle → Publisher 4. {ISBN, Author_Num} → BookTitle, LastName, Publisher, Royalty, Edition Write the types of functional dependencies shown in (1) to (4) above. Also, decompose the table to the third normal from (3NF).

icon
Related questions
Question
For the table BOOKAUTHOR below you are given the following functional dependencies.
BOOKAUTHOR (ISBN, BookTitle, Author_Num, LastName, Publisher, Royalty, Edition)
Functional dependencies:
1. ISBN
BookTitle, Publisher, Edition
2. Author Num → LastName
3. BookTitle → Publisher
4. {ISBN, Author_Num} → BookTitle, LastName, Publisher, Royalty, Edition
Write the types of functional dependencies shown in (1) to (4) above.
Also, decompose the table to the third normal from (3NF).
Transcribed Image Text:For the table BOOKAUTHOR below you are given the following functional dependencies. BOOKAUTHOR (ISBN, BookTitle, Author_Num, LastName, Publisher, Royalty, Edition) Functional dependencies: 1. ISBN BookTitle, Publisher, Edition 2. Author Num → LastName 3. BookTitle → Publisher 4. {ISBN, Author_Num} → BookTitle, LastName, Publisher, Royalty, Edition Write the types of functional dependencies shown in (1) to (4) above. Also, decompose the table to the third normal from (3NF).
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer