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).
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).
Related questions
Question
Draw tables to show the 3NF and dependencys
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
