Question
Can I get help with this question, please. Consider the following relation for published books: BOOK (Book_title, Authorname, Book_type, Listprice, Author_affil, Publisher). The primary key
Can I get help with this question, please.
Consider the following relation for published books: BOOK (Book_title, Authorname, Book_type, Listprice, Author_affil, Publisher).
The primary key for this relation: (Book_title, Authorname).
Author_affil refers to the affiliation of the author.
Suppose the following dependencies exist:
Book title -> Publisher, Book_type
Book_type -> Listprice
Author_name -> Author_affil
Using this information answer the following 2 questions and label your answers accordingly to their appropriate number.
1) Is this relation in 1NF, 2NF, or 3NF? Explain your answer.
2) How would you successively normalize it completely to 3NF? Specify the primary keys in each new table. State the reason behind each normalization.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started