erd
Tables (5)
book (Untitled5)
- bookno (Key) — int — Primary key — NOT NULL
- title (Field) — varchar
- author (Field2) — varchar
bookrent (Untitled4)
- bno (Key) — int — Primary key — NOT NULL
- rdate (Field) — date
- sno (Key2) — int — Foreign key → student.sno — NOT NULL
- bookno (Key3) — int — Foreign key → book.bookno — NOT NULL
dongari (Untitled3)
- no (Key) — int — Primary key — NOT NULL
- dname (Field) — varchar
dongari_join (Untitled2)
- dno (Key) — int — Primary key — NOT NULL
- rdate (Field) — date
- sno (Key2) — int — Foreign key → student.sno — NOT NULL
- no (Key3) — int — Foreign key → dongari.no — NOT NULL
student (Untitled)
- sno (Key) — int — Primary key — NOT NULL
- name (Field) — varchar
- department (Field2) — varchar