The relation LIBRARY records books currently on loan to students. Each book has one ISBN_NO The library has several copies of each book. A student may borrow more than one book but may not borrow a book they have already checked out. Assume also that no two library members have the same name.
ISBN_NO STUDENT_NAME STUDENT_ADDRESS
01 Liu Phelps
02 Liu Phelps
02 Holmes Phelps
03 Lopez Hollister
LIBRARY
a) Is LIBRARY in 1NF?
b) Identify candidate key(s)
c) Identify functional dependencies
d) Explain why is LIBRARY not in 2NF?
e) Decompose LIBRARY to comply with 2NF rules.