Question: The following attributes form a relation that includes information about the issue and return of books by students from a university library. Students of each
The following attributes form a relation that includes information about the issue and return of books by students from a university library. Students of each department in the university are authorized to issue and return the books after a specific time period (characterized with attributes Issue Start Date and Issue Ending Date). When the book is returned, the number of overdue days (the difference between Issue End Date and Return Date)
is computed. If it is positive, the fine imposed is calculated.
Students are identified by ID, Name, Course, and Department. Course and department names are unique.
Books are identified by ID, Title, Author, Publisher, and Edition.
The attributes are as follows:
BookIdentificationNo, BookTitle, BookAuthor, BookPublisher, BookEdition, StudentID, StudentName, StudentDepartment, StudentCourse, IssueID, IssueStartDate, IssueEndingDate, ReturnID, ReturnDate, OverdueDays, FineImposed.
Based on this information,
a. Identify the functional dependencies between the attributes.
b. Identify the reasons why this relation is not in 3NF.
c. Present the attributes organized so that the resulting relations are in 3NF.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
