== Релациска шема ==

=== Табели ===
'''Users'''
* (UserID, Username, Password, Email, Role)
'''Member'''
* (MemberID, Address, Phone, Membership_Status, UserID*(Users))
'''Book'''
* (BookID, ISBN, Title, Genre, PublishedYear, TotalCopies)
'''Book_Copies'''
* (CopyID, BookID*(Book), Condition)
'''Author'''
* (AuthorID, FirstName, LastName, Nationality, DateOfBirth)
'''Book_Author'''
* (BookID*(Book), AuthorID*(Author))
'''Loan'''
* (LoanID, LoanDate, ReturnDate, Status, BookCopyID*(Book_Copies), MemberID*(Member))
'''Fine'''
* (FineID, FineAmount, FineDate, Status, LoanID*(Loan))
'''FinePayment'''
* (FinePaymentID, PaymentDate, PaymentAmount, FineID*(Fine))

=== DDL скрипта за креирање и бришење на табелите ===
* [attachment:DDL-Script-BT.2.sql]

=== DML скрипта за полнење на табелите со податоци ===
 * [attachment:DML-Script-BT.sql]

== Релациски дијаграм изваден од DBeaver == 
[[Image(BookTracker - public.png)]]