Question 7 (Normalisation) - 35 marks b) Consider the following Book relation: a) Consider the following RECRUITEMENT relation with sample data. The BOOK (Book_title, Author_name, Book_type, List_price, Author_affiliation, primary keys are underlined. Publisher) Suppose the following dependencies exist: Book_title Publisher, Book_type Book_type List_price Author_name Author_affiliation Normalize the above BOOK table into 3NF. Show each normalization step clearly. You are not required to assume any additional dependencies. [15 marks] University ABC uses a single relation RECRUITEMENT to store its recruitment data. For each recruiter in University ABC, the table lists the number of recruited students from a particular city. It also lists the population of the cities and state from where University ABC recruits students. There can be more than one city with the same name, but within one state each city has a different name. Currently this table also lists the status of the recruiter and the population of the State and City. The primary key of this relation is the composite key RecruiterID, City and State. i) List down the full functional dependencies (on the primary key), partial dependencies (if any), and transitive dependencies (if any) in the RECRUITEMENT table. ii) Normalize RECRUITEMENT table to 3NF. Show each normalization step clearly