Task1 Check the following schema against the different normalization rules (i.e., 1NF, 2NF, 3NF, BCNF). Fix the schema if any of the normalization rules is violated BOOK (TitleNr, ISBN, CopyNr, Title, PublYear, Author, AuthorNat) CUSTOMER (CustomerNr, PersonNr, Name, Address, Tel, NrBooks) LOAN (TitleNr, CopyNr, CustomerNr, Date, BorrowerName) A table called BOOK, which contains data about the books -It has the attributes TitleNr (a number that this library assigns), ISBN, CopyNr (which is used to separate different copies of the same book), Title, PublYear, Author, and AuthorNat. The primary key consists of ISBN, CopyNr and Author. An alternative key consists of TitleNr, CopyNr and Author A table called CUSTOMER, which contains data about the persons who can borrow books. It has the attributes CustomerNr (a unique number identifying a person, assigned by the library), PersonNr (which is a unique number identifying a person, assigned by the Swedish state), Name, Address, Tel, and NrBooks (the number of books that this person has borrowed at the moment) A customer may have more than one telephone numbeir CustomerNr is the primary key. PersonNr is an alternative key. A table called LOAN, where the loans are stored. It has the attributes TitleNr, CopyNr, CustomerNr, Date (which is the date when the book was borrowed), and BorrowerName (which is the name of the customer who borrowed the book) -The primary key consists of TitleNr and CopyNr