Indicate all the functional dependencies and the normal form for each relation. Decompose your relations into 3rd normal form relations using the decomposition algorithm you will learn in the class. Make the necessary changes in the relations you already created and populated.

Has Publisher Book ID Title Address Book Author(s) Publisher ID Name Start Date Due Date Edition Borrow Transaction + Maintains Librarian Debt Borrow Transaction Number Employee ID Name Borrow Date Return Date Member Name Phone Number Member ID Surname Email