Library Management System ER Diagram

erDiagram
  BOOK ||--o{ BOOK_COPY : "has copies"
  BOOK ||--o{ BOOK_AUTHOR : "written by"
  AUTHOR ||--o{ BOOK_AUTHOR : writes
  MEMBER ||--o{ LOAN : borrows
  BOOK_COPY ||--o{ LOAN : "lent in"
  MEMBER ||--o{ RESERVATION : makes
  BOOK ||--o{ RESERVATION : "reserved in"
  LOAN ||--o| FINE : incurs
  BOOK {
    string isbn PK
    string title
    string publisher
    int year
  }
  AUTHOR {
    int author_id PK
    string name
  }
  BOOK_AUTHOR {
    string isbn FK
    int author_id FK
  }
  BOOK_COPY {
    int copy_id PK
    string isbn FK
    string status
    string shelf
  }
  MEMBER {
    int member_id PK
    string name
    string email
    string member_type
  }
  LOAN {
    int loan_id PK
    int copy_id FK
    int member_id FK
    date issue_date
    date due_date
    date return_date
  }
  RESERVATION {
    int reservation_id PK
    string isbn FK
    int member_id FK
    date reserved_on
  }
  FINE {
    int fine_id PK
    int loan_id FK
    decimal amount
    boolean paid
  }