Answer questions below regarding the relational database design for the R University book loan management database.
Book (Call_No, Title, AuthorID, Author_Bio, Location, Copy_Barcode, Status)
Semantics of attributes is self-explanatory. Some additional notes are as follows:
a. A call number is the combination of letters and numbers that indicates where books can be found in the library.
b. A book may have multiple book copies. Each book copy has a unique copy barcode. All copies of a book share same call number.
c. A book may have one or more authors and an author can write more than one book. Each author has some description (Author_Bio).
d. Status presents the status of a book copy e.g. available, on loan