Using the relations that you have defined for the library system, normalize your relations into first, second, and third normal form. Your output should be an Entity Relationship diagram that is in 3NF. All attributes, entities, keys, and relationships should be included and labeled. Although you do not need to include an ER diagram (unless you want to) for the relations in 1st normal form or 2nd normal form, you must describe the changes required to your relations to meet the standard of first 1st normal form and then 2nd normal form and of course 3rd normal form. Assignment Instructions: the assignment must define or describe the changes required to get the relations into the 1st normal form the assignment must define or describe the changes required to get the relations into the 2nd normal form the assignment should include an Entity Relationship diagram that details each of the following relations and their attributes in 3rd normal form. Book Borrower BookLended Librarian the primary and foreign keys, at a minimum are defined for each relation in the ER diagram the assignment should include an Entity Relationship diagram that details the relationships between Relations. Be sure to copy and paste this diagram into your assignment.