Library Management System

Tables (5)

Authors

  • author_id — number(10) — Primary key — NOT NULL
  • author_name — varchar2(30) — NOT NULL
  • book_id — number(10) — Foreign key → Books.book_id — NOT NULL

Books

  • book_id — number(10) — Primary key — NOT NULL
  • title — varchar2(100) — NOT NULL
  • genre — varchar2(30) — NOT NULL
  • pub_year — number(4) — NOT NULL
  • author_id — number(10) — NOT NULL
  • borrow_id — number(10) — Foreign key → Borrow.borrow_id — NOT NULL

Borrow

  • borrow_id — number(10) — Primary key — NOT NULL
  • book_id — number(10) — NOT NULL
  • mem_id — number(10) — NOT NULL
  • borrow_date — date — NOT NULL
  • return_date — date

Members

  • mem_id — number(10) — Primary key — NOT NULL
  • mem_name — varchar2(30) — NOT NULL
  • mem_phone — varchar2(15)
  • mem_email — varchar2(50)
  • borrow_id — number(10) — Foreign key → Borrow.borrow_id — NOT NULL

Staff

  • staff_id — number(10) — Primary key — NOT NULL
  • name — varchar2(30) — NOT NULL
  • role — varchar2(20) — NOT NULL