Fines
FineID INT
MemberID INT
IssueID INT
Amount DECIMAL
DateIssued DATE
DatePaid DATE
involves
ISSUE BookReviews
Reservations IssueID INT ReviewID INT
ReservationID INT CopyID INT BookID INT
CopyID INT MemberID INT MemberID INT
MemberID INT LoanDate DATE relates_to Rating INT
ReservationDate DATE DueDate DATE Comment TEXT
Status VARCHAR ReturnDate DATE ReviewDate DATE
involves
involves
refers_to
refers_to w ritten_by
Members
MemberID INT Librarians
BookCopies
FirstName VARCHAR LibrarianID INT
CopyID INT
LastName VARCHAR FirstName VARCHAR
BookID INT review s
Email VARCHAR LastName VARCHAR
BranchID INT
Phone VARCHAR Email VARCHAR BookAuthors
Status VARCHAR
Address VARCHAR Phone VARCHAR BookID INT
MembershipDate DATE BranchID INT AuthorID INT
relates_to relates_to
belongs_to
involves
w orks_at
LibraryBranches Books Authors
BranchID INT BookID INT AuthorID INT
BranchName VARCHAR Title VARCHAR FirstName VARCHAR
Address VARCHAR ISBN VARCHAR LastName VARCHAR
Phone VARCHAR PublicationYear INT Bio TEXT
PublisherID INT
CategoryID INT
Summary TEXT
belongs_to belongs_to
PublisherID CategoryID
Publishers Categories
PublisherID INT CategoryID INT
PublisherName VARCHAR CategoryName VARCHAR
Address VARCHAR
Phone VARCHAR