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