The relation LIBRARY records books currently on loan to students. Each book has one ISBN_NO The library has several copies of ea
ch 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.
1 answer:
You might be interested in
I do t know the answer to this but i think tou can firger it iut food luck
It took away jobs and made day to day tasks easier
Answer:
answer is D
Explanation:
as the block returns the number of array members, the most likely scenario is the last one.
Answer: yeah i mean i use my canon camera
Explanation:
Answer:
They allow you to ask more questions and also your rank goes up or down.
Explanation:
