member

PK member_no

lastname
firstname
middleinitial
photograph

item

PK

isbn

FK1 title_no

translation
cover
loanable

reservation

PK,FK1

isbn

PK,FK2

member_no

log_date
remarks

juvenile

PK,FK2

member_no

FK1

adult_member_no
birth_date

title

PK title_no

title
author
synopsis

loan

PK,FK1

isbn

PK,FK1

copy_no

FK3

title_no

FK2

member_no
out_date
due_date

loanhist

PK,FK1

isbn

PK,FK1

copy_no

PK

out_date

FK2

title_no
member_no
due_date
in_date
fine_assessed
fine_paid
fine_waived
remarks

adult

PK,FK1

member_no

street
city
state
zip
phone_no
expr_date

copy

PK,FK1

isbn

PK

copy_no

FK2

title_no
on_loan

Library

Database Diagram