Library

Tables (3)

Book

  • isbn — Primary key — NOT NULL
  • bauthor
  • bpubliser (bpublisher)
  • bname

Rental

  • rid — Primary key — NOT NULL
  • sid — Foreign key → Student.sid — NOT NULL
  • isbn — Foreign key → Book.isbn — NOT NULL
  • rdate
  • returndate

Student

  • sid — Primary key — NOT NULL
  • sname
  • s_email
  • sphone_number