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. 2. (5 pts) Define which of the provided functional dependencies may hold for the given relation. If the dependency does not hold, explain why by specifying tuples that cause the violation. A. Text -> Course Text Bartam Quarter Spring B. Text -> Instructor Instructor 1 Smith 2 Hall 3 Brown 4 Smith 5 Ross 6 Hall 7 Johnson Course Data Structures Systems Programming Programming Languages Data Structures Data Mining Systems Programming Databases C. Instructor -> Course Williams Summer Bartam Winter Williams Summer White Spring Elmasri Fall D. Course -> Text E. Course -> Quarter