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