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