Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. (15 pts) Consider following relation for published books: Book_type List_price Author_affil Publisher BOOK Book title Author name FD1 FD3 FD2 Author affil refers to
1. (15 pts) Consider following relation for published books: Book_type List_price Author_affil Publisher BOOK Book title Author name FD1 FD3 FD2 Author affil refers to the affiliation of the author. Primary key is {Book_title, Author_name}. Functional dependencies are: FD1: Book_title -> Publisher, Book_type FD2: Book_type -> List_price FD3: Author_name -> Author_affil a. (5 pts) What normal form this relation in (1NF, 2NF, 3NF)? Justify your answer by describing violations of normal forms (if any). b. (10 pts) Describe steps to normalize this relation up to 3NF. For full points, show all decomposed relations
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