Answer to Question #62360 in Databases | SQL | Oracle | MS Access for Chuks

Question

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

Answer 1

Dear Chuks, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order