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