Diagram bazy
danych biblioteki
member loan loanhist
PK member_no PK,FK1 isbn PK,FK1 isbn
PK,FK1 copy_no PK,FK1 copy_no
lastname PK out_date
firstname FK3 title_no
middleinitial FK2 member_no FK2 title_no
photograph out_date member_no
due_date due_date
reservation in_date
PK,FK1 isbn fine_assessed
PK,FK2 member_no fine_paid
fine_waived
log_date remarks
adult
remarks
PK,FK1 member_no
street
city
state
zip copy
phone_no item
expr_date PK,FK1 isbn
PK isbn PK copy_no
FK1 title_no FK2 title_no
translation on_loan
cover
loanable
title
juvenile
PK title_no
PK,FK2 member_no
title
FK1 adult_member_no author
birth_date synopsis