User

username
password
email
role (student/admin)
signup_date

signup()
login()

Rentals

rental_id (PK)
user_id (FK)
rental_date
due_date

return_date

rentBook()
calculate_fine()

Book

title (PK)
book_id (PK)
isbn
publication_year
total_copies
available_copies

updateCopies()

Author

author_id (PK)
author_name

Book Author

book_id (PK, FK)
author_id (PK, FK)
composite (PK)

Admin Log

log_id (PK)
admin_id (FK)

add_book()
delete_book()
manage_user()
rentBook()

Genres

genre_id (PK)
genre_name

writes

1*

1*

1*

1

*

1*

*