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 1^st normal form or 2^nd normal form, you must describe the changes required to your relations to meet the standard of first 1^st normal form and then 2^nd normal form and of course 3^rd 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.