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