List three benefits of normalizing a relation.
Define first normal form (1NF), second normal form (2NF), and third normal form (3NF).
Scenario for Questions 3-5
Consider the relation in answering the questions that follow. The relation is for a library which
maintains the below relation to store details of books that have been issued to members. Each book
has a unique ISBN number while the library may have multiple copies of a book with each having a
separate book number (Book_No). The library maintains records of only the current loans.