A university library system is responsible for tracking information about its books and users. At present, it offers lending facilities to over 5,000 students and has a catalog exceeding 1,000 books and periodicals. It is essential for the library to effectively keep track of what items have been borrowed, by whom, as well as which borrowers have outstanding fines (this may affect the number of items they can borrow). The data the library has available includes the following attributes:

BookCopyNo, BookISBN, Title, Author, Publisher, LoanStartDate, ReturnDate, StudentID, StudentFName, StudentLName, DegreeProgramme, Year, CurrentLoanNumber, OutstandingFines Sample data for this set of attributes is as follows:

12, 12203223232, Surviving University Life, Mr A N Other, Uni Books, {12/12/2018, 12/01/2019, 0292, John, Smith, Economics, 3, 12, False | 10/11/2018, 11/12/2018, 0402, Sarah, Chen, Computer Science, 1, 3, True |

04/08/2018, 04/09/2018, 0222, lai, Wit Yah, Economics, 2, 0, False | 23/04/2018, 23/05/2018, 0143, Saira, Saeed, Finance, 2, 4, True}

Note that the information for specific book copies is repeated four times in the sample data provided and is separated by the | symbol. Based on the facts stated above,

a. Identify the functional dependencies between the attributes.

b. Draw an ER diagram.

Field Exercises