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