2 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. EmpID Name Manager Dept Sector Children 285 Carl Smithers Engineering 6G David Carison 365 Lenny Smithers Marketing 8G Charls 458 Hamer Mr. Safety 7G Marge, Bart, Simpson Burns Lisa, Maggie