BOOKS

Tables (7)

BOOK (book)

  • Book_id — int — Primary key — NOT NULL
  • Title (title) — string
  • Publisher_name (p_name) — String — Foreign key → PUBLISHER.Name — NOT NULL

BOOK_AUTHORS (authors)

  • Author_name (name) — String — Primary key — NOT NULL
  • B_id (Book_id) — Int — Foreign key → BOOK.Book_id — NOT NULL

BOOK_COPIES (copies)

  • Book_id — int — Foreign key → BOOK.Book_id — NOT NULL
  • Branch_id (br_id) — int — Foreign key → LIBRARY_BRANCH.Branch_id — NOT NULL
  • No_of_copies (#copies) — int

BOOK_LOANS (loans)

  • Book_id — int — Foreign key → BOOK.Book_id — NOT NULL
  • Branch_id (br_id) — int — Foreign key → LIBRARY_BRANCH.Branch_id — NOT NULL
  • Card_no (Cno) — Int — Foreign key → BORROWER.Card_no — NOT NULL
  • Date_out — Timestamp
  • Due_date — Timstamp

BORROWER (borrower)

  • Card_no (Cno) — Int — Primary key — NOT NULL
  • Name (bo_name) — String
  • Address (bo_address) — String
  • Phone (bo_Phone) — String

LIBRARY_BRANCH (branch)

  • Branch_id (br_id) — int — Primary key — NOT NULL
  • Branch_name (br_name) — String
  • Address (br_address) — String

PUBLISHER (publisher)

  • Name (name) — String — Primary key — NOT NULL
  • Address (address) — String
  • Phone — Stirng