2 5 a) Consider the following relational schemes for a library database: Book (Title, Author, Catalog_no, Publisher, Year, Price) Collection (Title, Author, Catalog_no) the following are functional dependencies: Title Author --> Catalog_no Catalog_no --> Title Author Publisher Year Publisher Title Year --> Price Assume {Author, Title} is the key for both schemes. Apply the appropriate normal form for Book and Cancellation? b) Normalize the following table with different level of Normalization. 5 EmpID Name Manager Dept Sector Children Smithers Engineering 6G David 285 Carl Carison 365 8G Charls 458 Lenny Smithers Marketing Hamer Mr. Safety Simpson Burns 7G Marge, Bart, Lisa, Maggie